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


.