Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Selected Objects Clara Excel Worksheet Functions 4 June 28th 09 06:00 AM
Multiple cells or columns are selected instead of selected cell or Mikey Excel Discussion (Misc queries) 1 April 29th 09 09:48 PM
formula 2 display selected objects ONLY in new sheet from another Andrew Langner Excel Worksheet Functions 1 February 5th 09 01:31 AM
Deleting shapes/objects from a selected area Tim Excel Programming 1 October 23rd 04 01:00 AM
Deselect two objects after all selected Cutter[_14_] Excel Programming 3 August 8th 04 02:53 AM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"