Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Argument with onAction in a menu.
Hi out there!
I'v create a menu in a XL worksheet with commands like With Application.CommandBars.Add("Certifiering", , False, True) .Visible = True .Position = msoBarLeft With .Controls With .Add(msoControlPopup) .Caption = "&CertDatabas" With .Controls With .Add(msoControlButton) .Caption = "Spara öppen kopia" .OnAction = "Export_Data" End With Now I want to execute a sub from a .OnAction like With .Add(msoControlButton) .Caption = "Spara öppen kopia" .OnAction = "Export_Data argValue" End With Would realy appreciate a hint on how to do that, if it can be done! Regards Zeth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
Set up OnAction of a Menu Bar button to a function with variable in the parameters | Excel Discussion (Misc queries) | |||
Passing Parameters through OnAction | Excel Programming | |||
OnAction | Excel Programming | |||
OnAction | Excel Programming |