change button properties with variables

arie ribbens · #1 (**permalink**) 01-27-04, 08:53

Does anyone know how i can change the properties of a cmdbutton using variables?
It's hard to explain so i will give you some code...hope it will get clear:

Code:

Dim matrixindex As String
Dim buttonname As String

matrixindex = Sheets("matrix").Cells(1, 1)    
buttonname = "cmd" & matrixindex
         
Worksheets("matrix").buttonname.Caption = "1"

It seems like vba doesn't accept the variable ("buttonname") in that last line of code.

Hope someone can help.

Cheers Arie

redma_d · #2 (**permalink**) 02-02-04, 19:52

I kinda guessing really but is this what ya meant?

D

arie ribbens · #3 (**permalink**) 02-03-04, 17:27

thanks for your reply redma_d, but the code in the attachment is not exactly what i had in mind.
I recently figured it out and if anyone is interested this is the script that worked for me:

Code:

Worksheets("name").OLEObjects(varbuttonname).Object.Caption = "whatever you want"

Cheers,
Arie

Internet Services

Web Development

Digital Marketing

Consumer Tech