Listbox Scrollbar

fmascioni

New Member
Joined
Aug 11, 2008
Messages
46
Hello,

Does anyone know of a way using code to force a userform listbox scrollbar to scroll to the top of the list?

(setting the listindex to 0 is close but not exactly what I want)

Thanks
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
884
Hi

Try with code

Code:
Private Sub UserForm_Initialize()
    ListBox1.ListIndex = 0
End Sub
 

fmascioni

New Member
Joined
Aug 11, 2008
Messages
46
Yes, seems to work except for one problem now - when my listbox is empty I get an error message. I'm trying to add at least one "" item to get around that now..Hope it works.

Thanks!
 

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
884
is this works ?

Code:
Private Sub UserForm_Initialize()
    If ListBox1.ListCount > 0 Then ListBox1.ListIndex = 0
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,123,487
Messages
5,601,965
Members
414,487
Latest member
inxlsplot

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
Top