+ Reply to Thread
Results 1 to 3 of 3

User Form Error Messages

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    User Form Error Messages

    Hi.

    I have a user form with a few inputs (see attached image). A filename, subject, and email option all need to be entered/chosen.

    I would like to have a dynamic error message for the end user. How do I create the message box to show a message letting the user know which items are missing? For example, may be, "You are missing a filename," or, "You are missing a filename and subject," etc.

    Thanks.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    208

    Re: User Form Error Messages

    Something like the following might work for you. Obviously you would need to adjust the object names, and you can add others as needed.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Re: User Form Error Messages

    Thanks! Just a note to others who may find this, I tweaked it a little bit.
    Where there is, 'do stuff if there are no errors, I put:

    Please Login or Register  to view this content.
    and had success: starting after the end sub.

+ 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] User Form Facing Compile Error and Automation Error
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-14-2018, 01:05 PM
  2. [SOLVED] Expense claim form to bring error messages
    By MushroomFace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2013, 09:06 AM
  3. File Not Found error when opening User Form - need help tracing root of error
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2013, 03:48 PM
  4. Write a error messages when a given user haven't activated the right Data Object
    By Luonas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2012, 10:33 AM
  5. [SOLVED] Clearing a Combo Box then trying to submit user form to Workbook gives error messages
    By colvinb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2012, 02:18 PM
  6. Help with capturing user defined error messages.
    By Afro_code in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2006, 09:50 AM
  7. [SOLVED] Error messages from user defined Excel worksheet function
    By Helge V. Larsen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2006, 12:35 PM

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