+ Reply to Thread
Results 1 to 5 of 5

YES NO Button

  1. #1
    Registered User
    Join Date
    04-18-2017
    Location
    LONDON
    MS-Off Ver
    2013
    Posts
    19

    YES NO Button

    Hi

    I am having some trouble adding a Yes/No option to some code.

    The logic I would like to happen is as follows

    Press Button
    Pop Up Message appears saying "Are you sure you want to Archive"
    If yes RUN:

    Please Login or Register  to view this content.
    If no, Close and carry out no action.

    Any thoughts would be greatly appreciated.

    Thanks

    JDOPAL

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: YES NO Button

    Place this before the code that you want to run
    Please Login or Register  to view this content.
    End this just before the End Sub
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    04-18-2017
    Location
    LONDON
    MS-Off Ver
    2013
    Posts
    19

    Re: YES NO Button

    Amazing - and so simple, I was over thinking it.
    Thanks!

    JD

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: YES NO Button

    No problem, glad it worked for you.

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: YES NO Button

    jdopal1,

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Create running stopwatch/timer with 1 button (start/stop). No reset button.
    By leeroy2612 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2021, 12:59 AM
  2. Replies: 1
    Last Post: 02-27-2017, 09:17 AM
  3. [SOLVED] Form - select button & retrieve button name or button's caption
    By lexusap in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2016, 12:28 AM
  4. Replies: 1
    Last Post: 01-31-2016, 05:54 AM
  5. Replies: 0
    Last Post: 06-10-2014, 10:44 PM
  6. Button to copy specific cells to another sheet, lock button if cell has text
    By elmerg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 02:10 AM
  7. [SOLVED] Linking together an Options Button and a command button inorder to load separate forms
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 02:10 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