View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dianne Dianne is offline
external usenet poster
 
Posts: 107
Default User Form Initialization

In the UserForm_Activate or Initialize event, use:

TextBox1.SetFocus
(or whatever the name of your textbox is).

--
Dianne

In ,
Josh typed:
I have created a user form to input several pieces of
information with an "OK" button to process the data into
the correct fields. This user form is in a loop and
stops once all the information has been entered.

Right now, once the "OK" button is pressed, the OK button
is still selected and the user has to press either ENTER
or TAB to get to the first textbox. Is there a way to
position the cursor into the first textbox?

Thanks for your help.