"Bobby" wrote in message
...
On Apr 28, 3:39 pm, Mike wrote:
TRY THIS
Private Sub UserForm_Initialize()
TextBox3.SetFocus
End Sub



"Bobby" wrote:
Hi,
Could someone tell how to initialize or place the cursor in a specific
box on a userform, when I open the userform containing 4 text boxes.
By default it goes in the first one.

Thank's ahead.
.- Hide quoted text -

- Show quoted text -

Rick, to apply your recommandation regarding the usage of the group,
there are 3 buttons:

Reply Reply to author Forward

Which one should I use?

Regarding my last question, there no need for validation in this
Userform. Just an assignment to specific cell.
Thank's and regards.

In that case, I would just assign the TextBox's ControlSource property to
the cell you want to display the text in. You will find the ControlSource
property in the Project Properties window... just select the TextBox first,
then type in the address (along with its worksheet) in the space to the
right of the ControlSource property; for example, Sheet3!H7. You can do that
for each TextBox (using a different cell address, of course)... then, when
the user hits the Enter key or moves the focus to another control, the text
in the TextBox will be entered into the specified cell.

--
Rick (MVP - Excel)