+ Reply to Thread
Results 1 to 2 of 2

UserForm Error Message with Comments for Multiple Errors

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Baltimore
    MS-Off Ver
    2010
    Posts
    19

    UserForm Error Message with Comments for Multiple Errors

    Is there a way to create a UserForm macro that validates the user input values when the user pushes OK, and then return a list of all the errors?

    For example, after pushing OK, a box would pop up and say something like:
    "Please correct the following errors:
    > error 1
    > error 5
    > error 9"

    I can make several individual error messages, but I was just looking for a more eloquent way to do it. Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: UserForm Error Message with Comments for Multiple Errors

    Where Error and Error2 are defined variable strings;
    Please Login or Register  to view this content.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

+ 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] Userform Error Message on Listbox_Change Event
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2014, 10:44 PM
  2. Userform returning an error message
    By hstarr2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2013, 06:32 PM
  3. [SOLVED] Date in userform error message not working
    By cath1509 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2013, 03:21 PM
  4. Creating and error Message Userform
    By fredlo2010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 11:20 PM
  5. UserForm with Error Message
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2011, 04:52 AM

Tags for this Thread

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