carlAlex
9/19/2016 - 12:22 PM

VBA - Accessing a button caption

VBA - Accessing a button caption

Dim tekst as String

'Get the name of the button by right click, and read in the name area (top left)
tekst = ActiveSheet.Buttons("Knapp 30").Caption

ActiveSheet.Buttons("Knapp 30").Caption = "Balle klorin!"