Hi all, I have a button which when pressed opens a blank user form. I want to get that userform to display a range of cells on a sheet called ‘Mini’ and the range is B3:AR17.
Is it possible to get a userform to display a range and if so how would I go about doing this?
.
https://www.linkedin.com/pulse/how-v...assann-daphal/
However, I don't recall the max # of columns a ListBox can display ... that many columns may exceed the max.
You may need to break down the range into smaller segments and display each in its own ListBox.
Duplicate...
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
A listbox is a good idea for this as Logit suggested.
The max number of columns in a listbox is not known to me, but it should be no problem in this case. The AddItem method would limit you to 10, but using the rowsource property should work fine. Something like this in the UserForm Initialize code ought to work. Just adapt the sheet name and ListBox name.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks