Scroll vertical scrollbar to the bottom of list

[kelly mort]

Hi
Can I get a script to scroll the vertical scrollbar to the bottom of the list of a listbox?

I load the listbox each time I add data . So I will like to see the last item.

Thanks

 

[footoo]

.

 

[kelly mort]

I have the listbox on a userform will this do ?

It seems to me this code assumes the listbox is on a worksheet.

Regards
Kelly

 

[My Aswer Is This]

You would need something like this in your script:

ListBox1.ListIndex = ListBox1.ListCount - 1

 

[kelly mort]

Okay cool. @my answer is this

 

[My Aswer Is This]

Okay cool. @my answer is this

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[kelly mort]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

I just
I just fell into a trap:

I am sorting the data before loading the listbox so the last data might not be the current one.

Is there a way to get the current entered data selected?

Regards
Kelly

 

[My Aswer Is This]

Not sure what:

the current entered data selected is ​

 

[kelly mort]

Not sure what:

the current entered data selected is ​

Ime
I mean the last data entered. That should be at the last row but after the sort, it's place might change. So I am thinking if there is a way to find and select it

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.