listbox and vertical scrollbar
 

I have a userform with a listbox. The listbox has a vertical scrollbar.
However, each time the userform is loaded, the vertical scrollbar is at the
bottom of the list. How can I get the scroll, when loaded, at the top of my
list? Thanks in advance.

--
Message posted via http://www.officekb.com

listbox and vertical scrollbar
 

mtm

Me.ListBox1.TopIndex = 0

after you've populated it.

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

mtm4300 via OfficeKB.com wrote:
I have a userform with a listbox. The listbox has a vertical
scrollbar. However, each time the userform is loaded, the vertical
scrollbar is at the bottom of the list. How can I get the scroll,
when loaded, at the top of my list? Thanks in advance.