Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could use the shape's name to distinguish Comment from other
shapes. The following example selects the first shape in F2 whose name does not start with "Comment"... Option Explicit Sub select_shape() Dim Shp As Shape For Each Shp In ActiveSheet.Shapes If Shp.TopLeftCell = Range("F2") _ And Left(Shp.Name, 7) < "Comment" Then Shp.Select End If Next End Sub Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
Tooltip for Shape/Picture? | Excel Programming | |||
Shape/picture name in a worksheet | Excel Programming | |||
align a picture/shape in a Range! | Excel Programming | |||
I know selected picture is a shape but typename says is picture | Excel Programming |