How to write VBA code that waits for the user to select a chart?

I wrote some code that currently only works if a chart is already selected/activated before running the code.
Could you share a VBA example that waits for the user to activate a chart (or a shape object) before proceeding?
Is this an event-handling issue?

I tried assigning my subroutine to a rectangle shape-object on the same worksheet as the chart (poor man's button), but unfortunately this shape becomes the active object (stealing "active" status from the chart), so when it calls the sub, the sub just exits with an error. Would assigning this sub to a User Form button have the same outcome? I haven't experimented with making my own GUIs yet.

Thanks,
Geophysicist

Are you looking for something that's triggered by a user selecting a chart?

For that you can use Selection and check what's selected with TypeName.

Let me try to explain more clearly...

Once I execute the code, at a certain point I want it to pause until it receives a mouse click on a chart from the user (which would activate that chart), and then proceed with the rest of the instructions.

I've done a fair bit of research in the last two evenings, and have not yet found an example that shows code this general. It's always "exit sub if no chart was selected prior to executing the sub", or "set mychart equal to a known chart, and activate it (if not already active) before proceeding." In my case, I do not want to hardwire a known chart in the code, but rather, wait for the user to select a chart with a mouse click, and use that action as the chart selection to pass to "ActiveChart".

Again, if you have a coding example of this type of thing, or you know this to be beyond the capabilities of VBA, please post!

Cheers,
g