View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Using Application.Inputbox with shapes

Your observations are correct.

Work arounds would involve using two macros with the second triggered by the
selection. Use the onaction property of the rectangles to execute the second
macro.

an alternative may be to use application.Ontime to start the second after a
reasonable time to do the selection (although this is obviously not a good
way).

--
Regards,
Tom Ogilvy


"Chad" wrote:

I would like to allow prompt a user to select a shape (for example a
rectangle) Once they have done that I want to grab that shape's name and
position.

Currently what I have, prompts them to select the shape when they hit ok, it
exits from the macro. They then have to re-enter in to the macro to proceed.

I've looked into using Application.InputBox but it doesn't seem to allow the
user to select a shape on the sheet. Any help would be greatly appreciated.