Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |