I need to create several check boxes using VBA and I'm using the code below to test as I develop the feature.
Everything works as written except "BackColor" (in the example) and I can't figure out why.
The message is "Object doesn't support this property or method".
Can you please help? Thank you!
Sheets("Sheet1").CheckBoxes.Add(Left:=Range("B2").Left, Top:=Range("B2").Top, Width:=Range("C2").Width, Height:=Range("B2").Height).Select
.Caption = "Test"
.LinkedCell = "Sheet1!$C$2"
.BackColor = RGB(200, 200, 200)