Running a macro by clicking on any object

[vonRobbo]

Good day,

I'm putting together a spreadsheet that allows a user to step through the process of assembling a flow chart.

There will be "Start" (autoshape), which when clicked on, calls a userform which asks for information about the next step in the process. This will then insert an autoshape (with connecting arrows eventually) with the information that was just input by the user.

The user then clicks on the step they've just inserted and the userform runs again. So on, and so on.

I can't work out how to have a macro that runs if you click on ANY shape within the worksheet.

Any assistance you can provide is appreciated.

[mehmetcik]

Hi

The simplest way is to create a macro for every shape.

The macros all call a subroutine which is your main routine you can tell your routine which shape is calling if if required.

something like:-

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[vonRobbo]

Can I get it so a macro is written to each shape as it is created by the user?