Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm using a class to trap an embedded charts events. Private Sub EmbChart_Select(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long) If Arg2 < 0 Or ElementID < 3 Then Exit Sub Dim dblPotential As Double Dim dblEnergy As Double Dim sName As String sName = wksEmbchart.Range("inpName").Cells(Arg2, 1).Value dblPotential = wksEmbchart.Range("inpName").Cells(Arg2, 2).Value dblEnergy = wksEmbchart.Range("inpName").Cells(Arg2, 3).Value ...some more code here End Sub The code works just fine, there is however one slight problem. The user has to click the datapoint 2 times. The first click selects the series (Arg2 = -1) and not the point. Is there any way around this, i.e. can the user click the datapoint without the series getting selected? Regards Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox_Click event problem | Excel Programming | |||
Worksheet_Change event problem | Excel Programming | |||
SHdocVw event problem | Excel Programming | |||
Problem with Worksheet_Change event | Excel Programming |