Pass Shapes property names into module

Hi all,

Ok, i'm not an expert at all with programming, so please bear with me:

This is a dashboard design.

In my spreadsheet I have (example) 4 drawings (shapes) -> they are all arrows.

I have a column called STATUS which basically has list of GREEN, AMBER, RED, which I can select. Whenever I select the GREEN/AMBER/RED, the drawing change from UP, DOWN or HORIZONTAL.

Each arrows will have its own status.

Example:
CEll - STATUS - ARROW
Cell $C$5 - RED - DOWN
Cell $C$16 - AMBER - HORIZONTAL


so I have this as the 'main' in my Sheet1:

Please Login or Register  to view this content.

......and so on

Each of the CALL will have this:

Please Login or Register  to view this content.

.....

and so on.

this is quite cumbersome and what I need is to PASS the name of the SHAPES as parameter into the MODULE - just like passing the 'TARGET'

Call changeTrend(Target1) ->.

QS:

HOW do I pass the name of the shapes as parameter???

Thanks

Ok thanks for the two tips.

will give it a try.

actually i've got few sets of arrows, each set containing 'up', 'down', and 'horizontal'.

do i need unique names for each sets?