ListBox problem

dave8

Active Member
Joined
Jul 8, 2007
Messages
275
I have an Active-X listbox on a worksheet with properties set a multi and option. The problem is that when I fill the listbox with data, I can't access the last item in the listbox. The right scroll bar won't let me scroll down to look at the last item. Of course I can expand the height of the listbox, but thats not what I want to do. If the items of the list grows, I want to be able to use the scroll bar to go down the list. Anyone know why this is happening?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Hi, the menu Activex listbox must have the Enable scroll. try this
regards
 
Upvote 0
Hi, the menu Activex listbox must have the Enable scroll. try this
regards

I'm using 2007, but I don't see an Enable scroll anywhere in the listbox property. There is an Enable property and it's set to True, but I'm still having the problem. I do, however, see the scroll bar. I just can't scroll to the very end of the item record. It only scrolls next to the last.
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top