Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi NG!
Is it possible to serve many shapes with one Macro which expects a parameter? I get Errors like "expression too complex" (<--bumpy translation from german) My workaround would be using Application.Caller and a dictionary with appropriate parameters for each served shape. TIA Stefan |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Stefan,
Not sure because I've never tried, but surely it is much simpler to have one big macro that takes a parameter and a one line macro for each shape. I do this for all my Help files. Sub Help1() 'possibly in a form module or linked to a command bar RunHelp 1 End Sub Sub Help2() RunHelp 2 End Sub Public Sub RunHelp(nIndex) 'in a general module with option private module set in the declarations 'launch the associated help file based on the parameter End Sub HTH, Robin Hammond www.enhanceddatasystems.com "Stefan Rauchegger" wrote in message om... Hi NG! Is it possible to serve many shapes with one Macro which expects a parameter? I get Errors like "expression too complex" (<--bumpy translation from german) My workaround would be using Application.Caller and a dictionary with appropriate parameters for each served shape. TIA Stefan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Protect Sheet with Marcro | Excel Worksheet Functions | |||
Recording a marcro | Excel Discussion (Misc queries) | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |