View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sanjay[_2_] Sanjay[_2_] is offline
external usenet poster
 
Posts: 19
Default Evaluating if a Shape is a line or a shape

Thanks Vergel !



"Vergel Adriano" wrote in message
...
Sanjay,

I think you can check the Type property of the shape. If it's msoLine,
then
it's a line.

Sub test()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
If shp.Type = msoLine Then
'this is a line
Debug.Print shp.Name & " is a line."
End If
Next shp
End Sub

--
Hope that helps.

Vergel Adriano


"Sanjay" wrote:

Hi,

Is it possible to find out if a selected shape is just a line or a shape
(i.e. has a line color and fill color)

Thanks!