+ Reply to Thread
Results 1 to 3 of 3

UserForms - Check for Correct User Entry

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    Park City
    Posts
    59

    UserForms - Check for Correct User Entry

    I have a user form that I am trying to check for a correct user entry on a form text box:

    Please Login or Register  to view this content.
    If the sInput is "" there is nothing to tell the code to wait for another input and run the userform again.
    I feel like I need some type of GOTO statement to tell it to run the code again but I'm not sure how to do it.

    Help appreciated.

    GG

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: UserForms - Check for Correct User Entry

    Would it work for your needs to set the focus on sInput then exit the sub? The form will still be up if you exit prior to unloading the form:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-01-2008
    Location
    Park City
    Posts
    59

    Re: UserForms - Check for Correct User Entry

    Ha, so simple. Of course that's how it works. It makes perfect sense now that someone has shown me.

    Thanks,

    GG

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check cells are correct format and contain correct data
    By rikosborne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2014, 02:53 PM
  2. Create validation formula to check for correct user input?
    By chemoul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2012, 03:24 AM
  3. User Form Data entry trying to check that Data is entered right
    By CityMPLSEmpolyee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2012, 01:23 PM
  4. code to check if user opened correct file
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2010, 12:15 AM
  5. Check user entry
    By himanshu83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2010, 09:01 AM

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