Variable as button name

[mcasv]

Hello,

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?

Thanks.

[sweet_dreams]

Hi,

You can access ActiveX controls on sheet using OLEObjects collection:

    Dim strButtonName As String
    strButtonName = "cmdButton2"
    Sheets(1).OLEObjects(strButtonName).Object.BackColor = vbRed

If you command button is placed on form you can use Controls collection:

    Dim strButtonName As String
    strButtonName = "cmdButton1"
    Me.Controls(strButtonName).BackColor = vbBlue

Hope this helps.

Regards,
Sebastian

[mcasv]

Thanks you very much Sebastian.

It works well.