Thread: Selection type
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Selection type

Martin,

Use the TypeOf operator. E.g.,

If TypeOf Selection Is Excel.ChartArea Then
Debug.Print "Chart selected"
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Martin Stender" wrote in message
oups.com...
Hi all,

I have done a lot of VBA programming in PowerPoint, but I'm new
to
Excel.

Now, want to manipulate charts, but I cannot figure out how to
detect
if on or more charts on the active sheet are selected or not.

How do you discern between 'selection types' in Excel?

Thanks in advance! :-)

Martin