How do i put the cursor in TextBox in Userform automatically when form
is called by userform1.show. I want this for entering a password for
opening an excel file.

Please Tell Me


Mahesh Baldi
India

Try code like the following in the form's code module.

Private Sub UserForm_Activate()
Me.TextBox2.SetFocus
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Mahesh Baldi - India" wrote in message
oups.com...
How do i put the cursor in TextBox in Userform automatically
when form
is called by userform1.show. I want this for entering a
password for
opening an excel file.

Please Tell Me


Mahesh Baldi
India

there should be a option called Tab Index in the properties window.
Select the textbox you want as your password and set the TabIndex to 0.
You can go through the rest of your items and index them in order.
When someone hits tab it will go from 0--1--2 etc. When you add a
new item you will have to index it correctly.

Let me know if this helps.

-Justin