Text Box in UserForm in Excel

  Desert Andy 13:00 16 Mar 2007

I have programmed a few userforms in excel, which ask the user to input some data. I am sure I have used the same code every time; however, there is one userform where the textbox i want the user to enter data does not have the cursor flashing in it, so the user needs to select the textbox before typing in any data. How do I get the textbox active as soon as the userform is available to the user.

  VoG II 13:19 16 Mar 2007

In design mode:

Make sure no controls are selected.

Right-click in the form, but not on a control.

From the shortcut menu, choose Tab Order.

Select the name of the Listbox.

Choose Move Up until the Listbox name is at the top of the tab order.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone