Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form Initialization
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to control worksheet initialization upon opening a workbook | Excel Worksheet Functions | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
List box initialization | Excel Programming | |||
List box initialization | Excel Programming |