Russell Hauf
MrExcel MVP
- Joined
- Feb 10, 2002
- Messages
- 1,611
I have a list box that I'm filling dynamically (depends on the file being opened, there could be 1 item and there could be up to 100). When I'm done adding items, etc., I'm not able to scroll to the last item. The microsoft link below does not satisfy what I want to do. I don't want the list box to be as long as the list - I'm fine with the user scrolling to find what they want.
Here's what I've tried so far:
None of these has worked. I am using fixed numbers to set the height (this refers to the link below).
Any suggestions?
-Russell
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q211696
This message was edited by Russell Hauf on 2002-05-07 15:14
This message was edited by Russell Hauf on 2002-05-07 15:14
Here's what I've tried so far:
- Setting the height to smaller than I want, then back to the height I really want
- Setting the height to larger than the list, then back to my desired height (when I turn screenupdating on, I can see the last item when the list is made very tall - but it disappears once the height is set smaller again).
- Adding another item then deleting it
None of these has worked. I am using fixed numbers to set the height (this refers to the link below).
Any suggestions?
-Russell
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q211696
This message was edited by Russell Hauf on 2002-05-07 15:14
This message was edited by Russell Hauf on 2002-05-07 15:14