Using macro to create a Form Control Button and Assign macro to it in a specified Cell

**weige1989** · 10-30-2014, 01:18 AM

Hi,

Can someone please help me with a macro that can create a form control button and assign another macro to it, I would like to have control over where the button is created.

I have a code that allows me to create checkboxes but I'm not sure how to modify it for buttons and also to add macros.

Please Login or Register  to view this content.

Thanks alot!

**LJMetzger** · 10-30-2014, 06:16 AM

Hi weige1989,

You're doing fine.

To add a Macro you need .OnAction:

Please Login or Register  to view this content.

To add a Forms CommandButton:

Please Login or Register  to view this content.

To see how to add other types of Forms Controls, the 'MacroRecorder' may help you obtain the correct syntax.

Lewis

**weige1989** · 10-30-2014, 11:51 AM

It works, exactly what I needed. Thanks!

Using macro to create a Form Control Button and Assign macro to it in a specified Cell

LinkBack

Thread Tools

Rate This Thread

Display

Using macro to create a Form Control Button and Assign macro to it in a specified Cell

Re: Using macro to create a Form Control Button and Assign macro to it in a specified Cell

Re: Using macro to create a Form Control Button and Assign macro to it in a specified Cell

Thread Information

Users Browsing this Thread

Similar Threads

Workbook macro to automatically create a custom menu button and assign a macro to it.

how to assign a different macro to each*combobox selection in form control....

how to assign a different macro to each*combobox selection in form control....

A macro to create a form button, assign a macro and name the button

Assign Macro to Button control

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions