Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I trap selection of a shape?
ojv |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Shape has it own name.
if you click one, you'll notice the shape's name from the name box located left-top corner. you can select it with Shape object & it's name as following: Set shp = Sheet2.Shapes("AutoShape 1") shp.Flip msoFlipVertical ans also you can browse shape objects on a worksheet with For Each~Next Loop as followinf: Dim shp As Shape For Each shp In Sheet2.Shapes Debug.Print shp.Name Next -- msn --------------------------------------------- the best time to plant a tree was twenty years ago. the second best time, is today - Chinese proverb "ojv" wrote: How can I trap selection of a shape? ojv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
How to trigger a selection change between a cell and a shape | Excel Programming | |||
Shape Selection Name | Excel Programming | |||
Shape Selection Event !! | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |