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?
demo'd from the immediate window:
' two selected ? typename(selection) DrawingObjects ' one selected ? typename(selection) ChartArea If I put it in drawing mode from the drawing toolbar and forced it to actually select a single chart object it was ? typename(selection) ChartObject -- Regards, Tom Ogilvy "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?
A better test might be
if activechart is nothing then ' this would indicate that a single chart object is not select. What is select could be not a chartobject or multiple chartobjects If you want to know if it is multiple chartobjects, you can loop through the selection. again, from the immediate window: for each obj in selection: ?typename(obj): next ChartObject ChartObject -- Regards, Tom Ogilvy "Chimanrao" wrote: 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 | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
formula 2 display selected objects ONLY in new sheet from another | Excel Worksheet Functions | |||
Deleting shapes/objects from a selected area | Excel Programming | |||
Deselect two objects after all selected | Excel Programming |