OK, this is going to sound convoluted. We have some insanely complicated standards for doing Callouts (from the AutoShape list) in our documentation. I have managed to do macros for some aspects of it, but am far from satisified.
This is what I'd like:
1. Run the macro and popup a msgbox that tells the user to click on the graphic for the location they want the callout. (This part is no problem.)
2. Pause the macro while the user clicks the item to which the callout is pointing.
3. Have the macro record the coordinates of the click, and then draw a callout from that location to a spot above or below the graphic.
I have an existing macro that can format the callout from there.
Am I nuts for asking this or can this really be done? VBA has often surprised me with its functionality. I'm hoping for that here.