Hi guys,
I am relatively new to vba and was just wondering if someone could explain what each line of this code does as i am trying to create an animated chart.
Thanks in advance!![]()
Public Sub AnimateChart() Dim i As Integer bFinished = False ThisWorkbook.Names.Add "old", [chart_values] ThisWorkbook.Names.Add "switch_to_record", [record_index].Value If [b_animation] Then For i = 1 To [animation_steps] [step] = i DoEvents If bFinished Then Exit For Next i End If bFinished = True End Sub
Bookmarks