hi, i have a 6 text boxes which i only allow number to be entered. Bu
how can i make it so that when the user clicks accept, and a textbo
has a value higher than 16 or lower than 0, that box is selected; ha
focus?

here is what i have:

If Val(Sheet3.txtU1) 16 Or Val(Sheet3.txtU1) < 0 Then
MsgBox "Please enter a number between 0 and 16 for Unit 1."
vbOKOnly, "Invalid Value"
Sheet3.txtU2.SetFocus
End If

but set focus dosn't work. thanks for any help

--
Message posted from http://www.ExcelForum.com