P
PO
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
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