Attaching a macro to a VB button on a form

[WildGlio]

I have created a macro to select a row, copy it and then paste it below the
copied row. I want to attach this macro to a VB button labelled "Add Row" but
cannot work out how.

[Marc W.]

"WildGlio" wrote:

> I have created a macro to select a row, copy it and then paste it below the
> copied row. I want to attach this macro to a VB button labelled "Add Row" but
> cannot work out how.

Hi,

First off you need to make a "Forms" button not a "Control" button. A macro
can not be assigned to a "Control" button. After you make the button a window
will popup to assign the macro to the button. Just pick your macro from the
list.

Regards,
Marc

[WildGlio]

Many thanks Marc. I had not noticed the difference between the two
Toolbarmenus. I've got that bit working - thanks again.

"Marc W." wrote:

>
>
> "WildGlio" wrote:
>
> > I have created a macro to select a row, copy it and then paste it below the
> > copied row. I want to attach this macro to a VB button labelled "Add Row" but
> > cannot work out how.
>
> Hi,
>
> First off you need to make a "Forms" button not a "Control" button. A macro
> can not be assigned to a "Control" button. After you make the button a window
> will popup to assign the macro to the button. Just pick your macro from the
> list.
>
> Regards,
> Marc
>
>
>