Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
Am just getting into toolbars and custom menus that will call macros. Docum says in summary, for toolbars, .onaction = "MyMacro" 'with xxx and _ end with not shown. Well, I've got macros whose function varies via arguments. e.g. call RealMacro(arg1) Haven't yet read Walkenbach's chapter on menus, but as a heads-up I tried ..onaction = Run Macname "arg value" but of course it errored out. So, it seems unless there's a better way, that I'll have to have an "intermediate" call whe (in sorta pseudo code) .onaction = "MyMacA" .onaction = "MyMacB" sub MyMacA() call RealMacro("arg value A") end sub sub MyMacB() call RealMacro("arg value B") end sub Am I getting warm ? -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - onAction arguments | Excel Worksheet Functions | |||
OnAction with arguments supported | Excel Programming | |||
passing parameters to OnAction | Excel Programming | |||
.OnAction with arguments | Excel Programming | |||
How do you add arguments to an OnAction event? | Excel Programming |