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.
Featured
Writing your app was the hard part, but it’s not the last part. You still need to sell your app. Here's how to make sure your description puts your app in the best light. |
|
Reply With Quote
