Assign MAcro to command button

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

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.

acampbell...@yahoo.com 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