I have a Combolist box that has 39 entries. The screen isn't big enough for the entire list to be shown when the box is clicked and it truncates the top of the list. How can I add a scrollbar to this?
I have a Combolist box that has 39 entries. The screen isn't big enough for the entire list to be shown when the box is clicked and it truncates the top of the list. How can I add a scrollbar to this?
Last edited by jmoffett; 11-24-2008 at 09:24 PM.
A combobox automatically has a scrollbar if there are more items than the combobox is setup to display.
Just change the ListRows property of the combobox to only show like 4 or 5, then the rest of the 39 will be viewable via scroll bar. If this doesnt solve the problem, please post a sample of the workbook.
That fixed it. I had the number of rows to display as 39 and it was trying to show all of them at once. Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks