I am using macros in excel, and I want to use a variable to define the name of a button to change its backcolor. What Ive done is as follows:
lote = Label2.Caption
If OptionButton1.Value = True Then lote.BackColor = vbYellow
However it does not recognize lote as a button name to change the backcolor. Can anyone help me please?