+ Reply to Thread
Results 1 to 3 of 3

If cancel button is clicked then exit sub problem!?

  1. #1
    Registered User
    Join Date
    08-09-2011
    Location
    Utrecht
    MS-Off Ver
    Excel 2013
    Posts
    48

    If cancel button is clicked then exit sub problem!?

    Hello,

    The following macro will show an input screen and when the user is pressing the 'cancel' button than the sub must be stopped. I still have some issues because I keep receiving these errors. Can someone help me with resolving this problem.

    Please Login or Register  to view this content.
    Thanks for the help!

    Jeroen

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: If cancel button is clicked then exit sub problem!?

    Change
    Please Login or Register  to view this content.
    to (remove the space)
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    08-09-2011
    Location
    Utrecht
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: If cancel button is clicked then exit sub problem!?

    @Millz, thanks for the advise, however the error is still there. In the meantime I also came with a solution.

    Please Login or Register  to view this content.
    Thanks! Jeroen

+ 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. beforerightclick,exit sub, cancel=true, macro looping problem
    By newty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2014, 07:31 AM
  2. [SOLVED] user formm cancel button to exit multiple running subs
    By vijaysharmapc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2013, 02:55 PM
  3. Userform cancel button - how to exit multiple subs
    By sotiris5000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-16-2010, 09:56 AM
  4. tidy way to exit sub on cancel
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2009, 04:44 AM
  5. Exit Sub when I hit cancel
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2007, 01:27 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