tabbing
 

I want the list index to set when the person tabs over to the list box
from a text box.
how may I do that?

tabbing
 

I'm assuming you mean a listbox on a UserForm, not a listbox on a worksheet.

Do you know how to work with Events on the various controls and on the
UserForm?

For this task, you can use the Enter Event on the Listbox Object, which then
adjust the RowSource property on the Listbox as needed within that event.
Most of my form work comes from Access, which MSForms for Excel VBA has some
major differences from using Forms in Access.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"melissa" wrote in message
ups.com...
I want the list index to set when the person tabs over to the list box
from a text box.
how may I do that?