Scrolling to the bottom of listbox in VBA

[AVAYA123456]

Hi,

i am trying to display updates of a process to user using listbox. That is if user hits a command button i will add few lines to the already existing data in the list box using .AddItem. but after i did the list box always shows top lines and not the newly added lines in the bottom. Is it possible to additem to listbox and scroll to the bottom of listbox thru vba or do we have anyother way on doing this?

Thanks.

 

[Domenic]

You can use the TopIndex property. Here's an example...

[color=darkblue]Private[/color] [color=darkblue]Sub[/color] CommandButton1_Click()
    [color=darkblue]With[/color] Me.ListBox1
        .AddItem "Item1"
        .AddItem "Item2"
        .AddItem "Item3"
        .TopIndex = .ListCount - 1
    [color=darkblue]End[/color] [color=darkblue]With[/color]
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

Hope this helps!

 

[AVAYA123456]

Thanks Domenic. Its working.

 

[rap]

Hi Domenic,

Thank you very much for the code you have shared. It's working well!!!
Thanks again!