Userform Scrollbar VBA Excel

[cmxulb]

Hello,
Every time I data is entered I would have to scroll all the way down to see the results in a userform.
Is there a way that every time the value is saved to have the scrollbars go all the way down automatically? Like to show the last row.

 

[EXCEL MAX]

Hello Cmxulb,
you need to use listbox TopIndex property.
In your case...

ListBox1.TopIndex = ListBox1.ListCount

 

[cmxulb]

Hello Cmxulb,
you need to use listbox TopIndex property.
In your case...

ListBox1.TopIndex = ListBox1.ListCount

Hi Max, thanks for replying. where do I put the code?

 

[EXCEL MAX]

Depends.
You can choose between UserForm_Initialize and UserForm_Activate.
UserForm_Initialize run code only one time, but UserForm_Activate runs every time when UserForm be activated.