View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel User[_2_] Excel User[_2_] is offline
external usenet poster
 
Posts: 25
Default Group Name from a macro

Hi,

I have a group that is copied several times on a spreadsheet, the group
contains several shapes (shapea, shapeb, shapec and shaped) when the user
clicks the group I would like, ask which shape to bring to front of that
group, so far I have tried

groupname = Application.Caller
whichshape= Application.InputBox ("Which Shape")

msgbox (groupname )

But the groupname displays the actual underlining shape not the group, is it
possible to get the actual group name?

Thanks!