Excel VBA Macro Help

liam12989 · 2010-08-18 16:42:11

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.

18-08-2010 04:42PM

#1

liam12989

Registered Users, Registered Users 2 Posts: 545 ✭✭✭

Join Date: January 2009

Posts: 424

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.

0

Comments

#2 19-08-2010 11:26AM
Gosh

Registered Users, Registered Users 2 Posts: 684 ✭✭✭

Join Date: October 2004

Posts: 655
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

0