Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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