Assign MAcro to command button

[T De Villiers]

Hi, I have a macro in my workbook called REV,

I need to assign this macro to a commnd button.
The following is what I have so far, am clearly missing something
cos' its not quite working.

Many Thanks


Private Sub CommandButton1_Click()
REV
End Sub

[[email protected]]

Any error message?

T De Villiers wrote:
> Hi, I have a macro in my workbook called REV,
>
> I need to assign this macro to a commnd button.
> The following is what I have so far, am clearly missing something
> cos' its not quite working.
>
> Many Thanks
>
>
> Private Sub CommandButton1_Click()
> REV
> End Sub
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=568442

[[email protected]]

Many ways to do it but the easiest is.....

>From the toolbar menu select the forms toolbar
then pick command button to draw.
If should give you option to pick macro and assign if not right click
on it.

[email protected] wrote:
> Any error message?
>
> T De Villiers wrote:
> > Hi, I have a macro in my workbook called REV,
> >
> > I need to assign this macro to a commnd button.
> > The following is what I have so far, am clearly missing something
> > cos' its not quite working.
> >
> > Many Thanks
> >
> >
> > Private Sub CommandButton1_Click()
> > REV
> > End Sub
> >
> >
> > --
> > T De Villiers
> > ------------------------------------------------------------------------
> > T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
> > View this thread: http://www.excelforum.com/showthread...hreadid=568442

[Jim Thomlinson]

There are two kinds of command buttons. i am assuming that you grabbed your
button from the Control Toolbox and placed it on a sheet. When you do this
your sheet will be in design mode. If you right click on that button you can
change the properties and view the code. Select View code. It will take you
to the VBE and should have a stub entered for you similar to the code that
you posted... In that code add the line...

msgbox "tada"

and go back to your sheet. Exit design mode by clicking the Triangle icon on
the control toolbox. Now when you click the button your message box should
show up. Swap out the message box for REV and you should be off to the
races... If something crashes or does not work along the way post back...
--
HTH...

Jim Thomlinson


"T De Villiers" wrote:

>
> Hi, I have a macro in my workbook called REV,
>
> I need to assign this macro to a commnd button.
> The following is what I have so far, am clearly missing something
> cos' its not quite working.
>
> Many Thanks
>
>
> Private Sub CommandButton1_Click()
> REV
> End Sub
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=568442
>
>

[T De Villiers]

Many Thanks for this