LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default use mouseclick to dynamically change chart series? Chart_beforeDou

While this code works for clicking on the worksheet, my goal is to do this
by clicking on the graph itself to drill down through the data.
So I'm still back to trying to figure out the following, until/unless anyone
can give other options?

Sub Chart_BeforeDoubleClick(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
MsgBox "Test"
End Sub

Thanks!
Keith

"excelent" wrote in message
...
put in sheets kode window:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
MsgBox ("Double click on cells ") & ActiveCell.Address
End Sub



 
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
Dynamically change data in chart title Bill James Charts and Charting in Excel 2 January 9th 08 05:17 AM
How to dynamically change the series range of a chart ? ptek Charts and Charting in Excel 2 October 5th 06 04:42 AM
Change Chart Series with VBA Sueann Excel Programming 2 May 17th 06 09:57 PM
Change series in a chart trispirit32 Charts and Charting in Excel 2 July 26th 05 06:45 PM
Dynamically change column color in chart Everett[_2_] Excel Programming 1 August 7th 03 02:00 AM


All times are GMT +1. The time now is 04:37 PM.

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

About Us

"It's about Microsoft Excel"