I am trying to display a portion of my spreadsheet on a user form in VBA, the only thing I've seen so far is to right click on the toolbox and add another control called 'Microsoft Office Spreadsheet 11.0' however I don't see that as an option, although considering I have excel 2013 am not quite sure why. Any suggestions?
Hello cmurda,
Do you have a sample spreadsheet with a range you want displayed? Just remove any private information, or create a sample with dummy data.
Edit: Go to this link, about halfway down the page. Copy the code where it says to, and you will be done!
http://stackoverflow.com/questions/1...el-on-vba-form
Last edited by Loganeb; 10-28-2014 at 08:44 PM.
Please click the star (add rep) if I helped!
If you are displaying less than 10 columns, a multi-column list box is a quick way to display spreadsheet cells
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks