I have a user form with many text boxes, most of which I edit for validity.
If someone enters an invalid number, all I want to do is MsgBox them, clear
the textbox, and return the blinking cursor to that same textbox... well, I
have tried everything. I can clear the textbox, but I still have to use my
mouse to get back to that textbox. I have used the SetFocus, keybd_event to
tab backwards, and other tricks, none of which completely worked. Ideas?
--
Rich Locus
Logicwurks, LLC