Form Control Calling Macro

[geekgirlau]

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.