Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
I have a userform that a user inputs data into. I have
set up code that will give a message box if certain conditions are not satisfied when data is entered into a text box. When the user click OK on the msgbox, the textbox is cleared so the proper data can be input. If Len(txtStk.Value) < 5 Then MsgBox "Please Check Stock number" txtStk.Value = "" txtStk.SetFocus End If This all work fine, but the cursor moves to the next box in the tab order. I would like to cursor to stay in the txtStk text box. Can anyone see what I am doing wrong and please help me. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
if you are using the exit event, then setting Cancel = True will cause the
cursor not to move. -- Regards, Tom Ogilvy "Jenny" wrote in message ... I have a userform that a user inputs data into. I have set up code that will give a message box if certain conditions are not satisfied when data is entered into a text box. When the user click OK on the msgbox, the textbox is cleared so the proper data can be input. If Len(txtStk.Value) < 5 Then MsgBox "Please Check Stock number" txtStk.Value = "" txtStk.SetFocus End If This all work fine, but the cursor moves to the next box in the tab order. I would like to cursor to stay in the txtStk text box. Can anyone see what I am doing wrong and please help me. Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
Hi
in which event do you put this code. Normally this should work? -- Regards Frank Kabel Frankfurt, Germany "Jenny" schrieb im Newsbeitrag ... I have a userform that a user inputs data into. I have set up code that will give a message box if certain conditions are not satisfied when data is entered into a text box. When the user click OK on the msgbox, the textbox is cleared so the proper data can be input. If Len(txtStk.Value) < 5 Then MsgBox "Please Check Stock number" txtStk.Value = "" txtStk.SetFocus End If This all work fine, but the cursor moves to the next box in the tab order. I would like to cursor to stay in the txtStk text box. Can anyone see what I am doing wrong and please help me. Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
I am using the "afterupdate" event.
Thanks again -----Original Message----- if you are using the exit event, then setting Cancel = True will cause the cursor not to move. -- Regards, Tom Ogilvy "Jenny" wrote in message ... I have a userform that a user inputs data into. I have set up code that will give a message box if certain conditions are not satisfied when data is entered into a text box. When the user click OK on the msgbox, the textbox is cleared so the proper data can be input. If Len(txtStk.Value) < 5 Then MsgBox "Please Check Stock number" txtStk.Value = "" txtStk.SetFocus End If This all work fine, but the cursor moves to the next box in the tab order. I would like to cursor to stay in the txtStk text box. Can anyone see what I am doing wrong and please help me. Thank you . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
If your main purpose is to validate the entry then I would use the exit
event and take advantage of the Cancel argument. -- Regards, Tom Ogilvy "Jenny" wrote in message ... I am using the "afterupdate" event. Thanks again -----Original Message----- if you are using the exit event, then setting Cancel = True will cause the cursor not to move. -- Regards, Tom Ogilvy "Jenny" wrote in message ... I have a userform that a user inputs data into. I have set up code that will give a message box if certain conditions are not satisfied when data is entered into a text box. When the user click OK on the msgbox, the textbox is cleared so the proper data can be input. If Len(txtStk.Value) < 5 Then MsgBox "Please Check Stock number" txtStk.Value = "" txtStk.SetFocus End If This all work fine, but the cursor moves to the next box in the tab order. I would like to cursor to stay in the txtStk text box. Can anyone see what I am doing wrong and please help me. Thank you . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform | Excel Discussion (Misc queries) | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Little bug in my userform | Excel Programming | |||
Userform inside another userform | Excel Programming |