Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing properties to a procedure
I've got a spreadsheet that uses "traffic lights" to
indicate the health of different parts of the business. These traffic lights are just circles drawn with the autoshapes option, and then given background colours of green, orange and red. I've written a simple macro that can be assigned to a circle that changes the colour from green to orange to red and back to green as you click on the circle. However, I've got a lot of circles and I don't want to write individual macros for each - I want to be able to assign the same macro to each one. How can I change my macro so that it realises that the circle I want to change is the one I've just clicked on? The steps I would want are that you click on the circle and macro says - ah, you've clicked on "Oval X" and then runs the code based on this selection. My current solution which requires me to tell the macro which circle to change (i.e. Shapes("Oval X").Select). Regards, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop a Procedure from another procedure | Excel Discussion (Misc queries) | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
Passing parameter from Excel to stored procedure? | Excel Programming | |||
Passing a Password to a VBA Procedure | Excel Programming |