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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel VBA Macro Help

  • 18-08-2010 4: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: 683 ✭✭✭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