C
Creepy
Guest
Bonjour All,
Voila j'ai pompé un code VBA, car je ne savais absolument pas faire. Le code marche très bien, mais j'avoue ne pas comprendre tout !!
Comme je veux pas copier bêtement, je veux comprendre, kk1 pourrait t'il m'expliquer ce que fait ce code en detail (j'ai deja des morceaux mais pas toute l'histoire).
Merci d'avance
Creepy
Private Sub CommandButton1_Click()
Dim Counter, countseries, xseries As Integer, ChartName As Variant
Dim xVals As Variant, xCell As Variant
Dim xwcell As Range
'Application.ScreenUpdating = False
Graph2.Select
countseries = ActiveChart.SeriesCollection.Count
For xseries = 1 To countseries
Counter = 1
xVals = ActiveChart.SeriesCollection(xseries).Formula
xVals = Right(xVals, Len(xVals) - InStr(1, xVals, ","))
xVals = Left(xVals, InStr(1, xVals, ",") - 1)
For Each xCell In Range(xVals)
Set xwcell = Range(xCell.Offset(-11, 0).Address)
ActiveChart.SeriesCollection(xseries).Points(Counter).HasDataLabel = True
ActiveChart.SeriesCollection(xseries).Points(Counter).DataLabel.Text = xwcell.Value
Counter = Counter + 1
Next xCell
Next xseries
' Application.ExecuteExcel4Macro "SELECT("""")"
End Sub
Voila j'ai pompé un code VBA, car je ne savais absolument pas faire. Le code marche très bien, mais j'avoue ne pas comprendre tout !!
Comme je veux pas copier bêtement, je veux comprendre, kk1 pourrait t'il m'expliquer ce que fait ce code en detail (j'ai deja des morceaux mais pas toute l'histoire).
Merci d'avance
Creepy
Private Sub CommandButton1_Click()
Dim Counter, countseries, xseries As Integer, ChartName As Variant
Dim xVals As Variant, xCell As Variant
Dim xwcell As Range
'Application.ScreenUpdating = False
Graph2.Select
countseries = ActiveChart.SeriesCollection.Count
For xseries = 1 To countseries
Counter = 1
xVals = ActiveChart.SeriesCollection(xseries).Formula
xVals = Right(xVals, Len(xVals) - InStr(1, xVals, ","))
xVals = Left(xVals, InStr(1, xVals, ",") - 1)
For Each xCell In Range(xVals)
Set xwcell = Range(xCell.Offset(-11, 0).Address)
ActiveChart.SeriesCollection(xseries).Points(Counter).HasDataLabel = True
ActiveChart.SeriesCollection(xseries).Points(Counter).DataLabel.Text = xwcell.Value
Counter = Counter + 1
Next xCell
Next xseries
' Application.ExecuteExcel4Macro "SELECT("""")"
End Sub