tabbing

  • Thread starter Thread starter melissa
  • Start date Start date
M

melissa

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oversensitive touchpad on modern laptops 0
Disable new grid Chrome tabs on Android 9
Excel Move or Copy Stopped Working? 0
Tab character in a Text Box 1
Tab Index Not working? 1
Click event for UserForm Multipage 1
How do I automate the moving between tabs in a form? 1
EXCEL DROP DOWN 2

Back
Top