Listbox Selection

[melissa]

hello, I need some assistance.

I would like to have the first item in my listbox be the default
selection.
Also, I would like the selection to move as the person scrolls through
the items.

It is a listbox with state abbreviations for an address.

I am using excel 2000.

Is this possible?

 

[Rick Rothstein \(MVP - VB\)]

I would like to have the first item in my listbox be the

default selection.

After you load your items, use this line to select the first item...

ListBox1.ListIndex = 0

where I have assumed your ListBox is named ListBox1.

Also, I would like the selection to move as the person
scrolls through the items.

I'm not sure that is possible to do; but, if it was, it would be
non-standard.

Rick

 

[melissa]

After you load your items, use this line to select the first item...

ListBox1.ListIndex = 0

where I have assumed your ListBox is named ListBox1.


I'm not sure that is possible to do; but, if it was, it would be
non-standard.

Rick

thanks!