have 2 fields on a user form. when textbox1 is exited, it looks up the value
and stores it in a variable. if i don't find it, i pop a message box but i'm
having a problem setting the focus back to textbox1. it always goes to
textbox2 even thought i set focus back to textbox1.

what's the best way to only go to textbox 2 if it finds the value entered
into textbox1, otherwise clear textbox1 and set the focus.

unloading and loading the form works, but just looking for a better way.
--

Gary Keramidas
Excel 2003