1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Private Sub chart_MouseMove(ByVal Button As Long, ByVal Shift As Long, _
ByVal x As Long, ByVal y As Long)
Dim ElementID As Long
Dim Arg1 As Long, Arg2 As Long
On Error Resume Next
ActiveChart.GetChartElement x, y, ElementID, Arg1, Arg2
ActiveChart.Shapes("Text Box 1").Visible = msoFalse
If (Arg1 = 1 And ElementID <> 15 And ElementID <> 21) Then
If Arg2 = 0 Then
ActiveChart.Shapes("Text Box 1").Visible = msoFalse
Else
With ActiveChart.Shapes("Text Box 1")
.MultiLine = True
.Visible = msoTrue
.TextFrame.Characters.Text = _
vbTab & " " & Range("Graphe").Offset(Arg2, 0) & " " & vbCrLf _
& vbTab & " Ret0Eqty : " & Format(Range("Graphe").Offset(Arg2, 3), "0.00%") & " " & vbCrLf _
& vbTab & " Prc2Bk : " & Format(Range("Graphe").Offset(Arg2, 2), "0.00x") & " " & vbCrLf _
& vbTab & " Quintile : " & Range("Graphe").Offset(Arg2, 1)
End With
End If
End If
End Sub |
Partager