Thread: On Action
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
borg borg is offline
external usenet poster
 
Posts: 23
Default On Action

Hi,

I have drawn a rectangle and assigned a macro to it. When I click on this
rectangle, I would like the macro to display the position of the rectangle.

My macro looks something like this:

sub macro1
msgbox selection.top
end sub

I am guessing this doesn't work because the rectangle is not selected when
the macro is running? If you can help, it is greatly appreciated.

Thanks!