Form: texbox navigation

I have a form set up with excel (2003) using vba. I'm doing a check to see if textbox1 is empty, if it is, a msgbox pops up with a warning that "textbox1 needs to be filled out". I click OK and the cursor goes to textbox2. I want the cursor to return to texbox1 without user intervention but can't figure out how. I'm using "Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)".
I know it can be done because I did it with vba Access, but I can't seem to find it using vba Excel. Any help would be appreciated.

You need to set focus to the control

Please Login or Register  to view this content.

Please use code tags when post any code.

Can you post your workbook?

The main workbook is at work, but I just created a simple form with 2 textboxes to test.
this is the code I'm testing

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Thanks for taking the time to read and comply with the rule .