+ Reply to Thread
Results 1 to 1 of 1

How to capture return value from data validation error message box

  1. #1
    Registered User
    Join Date
    05-20-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2002
    Posts
    12

    How to capture return value from data validation error message box

    I'm using data validation with alert set to information. The error message box has the options of OK or CANCEL. How can I capture the return value if OK is clicked, so that I can then trigger a macro? Any pointers or ideas on a VBA solution will be greatly appreciated. Many thanks.
    Last edited by franklyn; 08-14-2012 at 02:47 PM.

+ Reply to Thread

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