Use Activate not SetFocu
Sheet3.txtU2.Activate
----- Chrome wrote: ----

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 The
MsgBox "Please enter a number between 0 and 16 for Unit 1."
vbOKOnly, "Invalid Value
Sheet3.txtU2.SetFocu
End I

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


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