Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if multiple chart objects are selected?
hi
how do i find if multiple chart objects are selected by the user using the ctrl + click mechanism? chiman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if multiple chart objects are selected?
TypeName(Selection) returns "DrawingObjects" if more than one chart is
selected. "Chimanrao" wrote: hi how do i find if multiple chart objects are selected by the user using the ctrl + click mechanism? chiman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find if multiple chart objects are selected?
Sub test()
Dim ob As Object, s As String If TypeName(Selection) = "DrawingObjects" Then For Each ob In Selection If TypeName(ob) = "ChartObject" Then cnt = cnt + 1 End If Next s = cnt & " / " & Selection.Count & _ " selected objects are ChartObjects" Else s = TypeName(Selection) End If MsgBox s End Sub Strangely, when I first tested in Excel 97 if multiple chartobjects and only chartobjects were selected TypeName(Selection) returned "ChartObject". But later in testing it returned "DrawingObjects" same as later versions. Odd! Regards, Peter T "Chimanrao" wrote in message oups.com... hi how do i find if multiple chart objects are selected by the user using the ctrl + click mechanism? chiman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Selected Objects | Excel Worksheet Functions | |||
formula 2 display selected objects ONLY in new sheet from another | Excel Worksheet Functions | |||
how to find if multiple chart objects are selected? | Excel Programming | |||
Deleting shapes/objects from a selected area | Excel Programming | |||
Deselect two objects after all selected | Excel Programming |