Assigning Macro to VBA added DropDown boxes

[gruberm]

Hello,

First off, thank you for taking the time to read and hopefully answer this post.

I have a macro that creates dropdown boxes (amongst other things) iteratively via a spinner button. I wish for these dropdown boxes to call upon another macro (ReservesMovement) that uses a Case value to decided how to format the criteria, based on the value of the added Dropdown box.

I am having trouble finding a way to assign the Reserves Movement macro to the newly added dropdown boxes. Ultimately I will want the macro to recognize which dropdown box I am changing and just reformat the cells that I've assigned to that dropdown box.

Many thanks in advance for your help.

Matt

[Norie]

Matt

What type of dropdowns are you adding?

[Jakobshavn]

Post a small sample of what you now have.

[gruberm]

They are Combobox form controls added via VBA.

Below is the code where I've added the dropdowns but I haven't had an issue with that. I would now like to assign these drop downs to a seperate macro, just as one would do via a right click on the mouse, manually.

Please Login or Register  to view this content.

Thanks!

[Norie]

Matt

You can use the OnAction property to assign a macro to a Forms control.

Please Login or Register  to view this content.

[gruberm]

that was the trick I needed. Thank you Norie!