+ Reply to Thread
Results 1 to 4 of 4

Merge Macro error when clicking Cancel

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    90

    Merge Macro error when clicking Cancel

    I have a simplistic Macro that is just
    Please Login or Register  to view this content.
    But if I hit the [x] or cancel, I get an error message. Do I use
    Please Login or Register  to view this content.
    or do I use something else? Since it's an excel primary error msgbox I'm not sure how I'd reference it.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merge Macro error when clicking Cancel

    Depending on the behavior you want,

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    90

    Re: Merge Macro error when clicking Cancel

    So the 1st one just doesn't give me an error when I click cancel, whereas the second one just doesn't allow that initial msgbox to appear? Now you've given me a tough decision haha but you answered my question so thank you very much!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merge Macro error when clicking Cancel

    You're welcome.

+ 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. Error message when clicking on a command button asigned a macro
    By steve123456 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2012, 01:43 AM
  2. Cancel button on form deletes text and needs clicking twice
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2010, 11:51 AM
  3. How to avoid an error, if you press cancel on a SAVE FILE-Macro
    By Silas313 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2010, 04:56 AM
  4. Cancel on INPUTBOX macro causes error
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2006, 07:35 PM
  5. Cancel Macro is user selects 'cancel' at save menu
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2005, 01:06 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