Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel VBA Macro Help

  • 18-08-2010 05:42PM
    #1
    liam12989
    Registered Users, Registered Users 2 Posts: 545 ✭✭✭


    Im just looking for a bit of help. I have my macro recorded. I just want to put it into a command button on a userform.the code bit. so when i run it and press button my macro will show up and form wil disappear.


Comments

  • #2
    Gosh
    Registered Users, Registered Users 2 Posts: 684 ✭✭✭Gosh


    The simplest option without creating a form and button would be to include something like the following code at the beginning of your macro
    MsgBox("Press OK to Proceed")
    If you wanted to give the option to Cancel as well then something like
    If MsgBox("Press OK to Proceed or Cancel to Quit", vbOKCancel) = vbCancel Then
   Exit Sub
End If


Advertisement