ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to find if diagram is selected? (https://www.excelbanter.com/excel-programming/345350-how-find-if-diagram-selected.html)

Chimanrao

how to find if diagram is selected?
 
how do I find if a diagram is selected by the user?


Jim Rech

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?
|



Chimanrao

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



All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com