Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 CommandButton controls (cmd_1, cmd_2, ... cmd_10)
I want to be able to cycle through them to change their attributes using data stored in an array cb(10). I know I'm missing something simple, but integral. Can anyone help? I've tried: Dim myObj as Object Dim x as Interger For x = 1 to 10 Set myObj = "cmd_" & x With myObj .Visible = cb(x) End With Next x |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Controls Array | Excel Programming | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
array of userform controls | Excel Programming | |||
excel VBA set array controls | Excel Programming | |||
Setting attributes for controls | Excel Programming |