Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Shape Marcro with Parameter

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default Shape Marcro with Parameter

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
my curser changed from arrow shape to a cross shape???? bj New Users to Excel 1 February 5th 07 02:47 PM
Protect Sheet with Marcro Conditional Formatting Excel Worksheet Functions 1 December 21st 05 07:40 PM
Recording a marcro carrera Excel Discussion (Misc queries) 6 May 13th 05 05:40 PM
Deleting a shape and the cell contents the shape is in. Dave Peterson[_3_] Excel Programming 1 October 9th 03 03:36 PM
Deleting a shape and the cell contents the shape is in. Tom Ogilvy Excel Programming 0 October 9th 03 03:43 AM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"