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
|