Results 1 to 9 of 9

Form: texbox navigation

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    5

    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.
    Last edited by nglow; 07-04-2009 at 08:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1