List Box Selection

[James W.]

Quick list box question...
How can I have the last row in a list box selected when my user form is
loaded.

[Harald Staff]

Hi

Put

List1.Listindex = List1.Listcount-1

in the form's Initialize event.

HTH. Best wishes Harald

"James W." <JamesW@discussions.microsoft.com> skrev i melding
news:0564C141-B069-4D43-9BAE-0CCD63258D2E@microsoft.com...
> Quick list box question...
> How can I have the last row in a list box selected when my user form is
> loaded.
>
>