Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Option Explicit
Sub TheDrawingObject() Dim myShape as shape set myshape = activesheet.shapes(application.caller) 'just to show a few ways to get it and other options msgbox application.caller _ & vblf & myshape.name _ & vblf & myshape.topleftcell.address End sub Troubled User wrote: I need to get the name of a drawing object when I click it via a left click, something like: Sub TheDrawingObject msgbox(me.name) End Sub I need to assign it to a variable. Any help would be greatly appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Drawing Object By Name | Excel Programming | |||
Floating Drawing Object | Excel Programming | |||
Drawing Object | Excel Programming | |||
Selecting drawing objects or shapes in a macro | Excel Programming | |||
Drawing object references | Excel Programming |