Form Control Calling Macro

[pcstru]

If you can't select a macro with a parameter, what about creating a new macro. Your new macro would simply call the first macro and set the parameter, and your control would run the new macro on entry/exit.

[vba]
Sub MyNewMacro
MyRealMacro "ControlName"
End Sub
[/vba]
Clunky I know, but it will work.

That would work, requires a macro for each dropdown and there will be ~100 dropdowns. Still, would be quicker than looping through each control. Thanks.