Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

**Un-Do Re-Do** · 08-18-2018, 04:10 AM

Is there a way to assign a macro to a Combo Box (Form Control) using VBA, rather than right-clicking in Excel and selecting "Assign Macro"?

**Andy Pope** · 08-18-2018, 04:34 AM

Use the OnAction property.

example where subroutine Test is assigned to combobox.

Please Login or Register  to view this content.

**Un-Do Re-Do** · 08-18-2018, 04:47 AM

Appreciate the response. It works as intended.

**Un-Do Re-Do** · 09-01-2018, 09:47 PM

Is it possible to assign the macro from an Add-In?
I tried sheet1.Shapes("Drop Down 1").OnAction ="MyAddIn.xlam!Test" but it did not wok.
Does the folder directory of the Add-In have to be specified? The reason is that I use 2 computers.

Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

LinkBack

Thread Tools

Rate This Thread

Display

Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

Re: Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

Re: Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

Re: Assign a macro to a Combo Box (Form Control) ... via VBA ... not right clickIs

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Assign macro on spin button on sheet (form control)

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

Code works with Combo Box-Form Control, but not with Combo box - ActiveX Control

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....

[SOLVED] Combo Box (Form Control) With Macro On A Graph Sheet

Assigned Macro to Combo Box(Form Control)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions