View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DanB DanB is offline
external usenet poster
 
Posts: 12
Default Reference Controls to chang attributes through Array

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