Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform setfocus question
is there any way to get the cursor in a certain text box? when i leave a textbox
and the entry isn't valid, i would like to get the cursor back in that textbox. setfocus only seems to work when the form is activated. -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform setfocus question
Gary ,
Do you open another userform when leaving the textbox? If not , your userform will remain active as your controls on this userform. so , textbox1.setfocus should do the trick when the entry is invalid. otherwise , post a little of your code , so we can check what's wrong. MarMo "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... is there any way to get the cursor in a certain text box? when i leave a textbox and the entry isn't valid, i would like to get the cursor back in that textbox. setfocus only seems to work when the form is activated. -- Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform setfocus question
Private Sub CommandButton2_Click() Me.TextBox1.Value = "" Me.TextBox2.Value = "" Me.TextBox3.Value = "" Me.TextBox2.SetFocus End Sub -- Gary "MarMo" wrote in message ... Gary , Do you open another userform when leaving the textbox? If not , your userform will remain active as your controls on this userform. so , textbox1.setfocus should do the trick when the entry is invalid. otherwise , post a little of your code , so we can check what's wrong. MarMo "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... is there any way to get the cursor in a certain text box? when i leave a textbox and the entry isn't valid, i would like to get the cursor back in that textbox. setfocus only seems to work when the form is activated. -- Gary |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform setfocus question
does anybody know of a way to do this?
-- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... is there any way to get the cursor in a certain text box? when i leave a textbox and the entry isn't valid, i would like to get the cursor back in that textbox. setfocus only seems to work when the form is activated. -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform SetFocus with Exit and Cancel | Excel Programming | |||
Userform setfocus problem | Excel Programming | |||
SetFocus Question | Excel Programming | |||
SetFocus to first textbox on userform upon Userform1.Show | Excel Programming | |||
UserForm1.Textbox1.SetFocus Question | Excel Programming |