Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if diagram is selected?
how do I find if a diagram is selected by the user?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if diagram is selected?
Quick and dirty but seems to work:
Sub a() Dim x As Object Set x = Selection On Error GoTo NotDiagram If x.ShapeRange.Type = msoDiagram Then MsgBox "Diagram selected" Else Err.Raise 10000 End If Exit Sub NotDiagram: MsgBox "Not a diagram" End Sub -- Jim "Chimanrao" wrote in message oups.com... | how do I find if a diagram is selected by the user? | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if diagram is selected?
Can you give an example in C++, not sure if Object is a valid class in
C++. Regards Chimanrao |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find out how many rows I have selected? | Excel Discussion (Misc queries) | |||
Find out what is selected for AutoFilter | Excel Programming | |||
How do i find items selected in a list box ? | Excel Programming | |||
Find Findnext in selected range | Excel Programming | |||
How to find out what the user selected? | Excel Programming |