View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason[_31_] Jason[_31_] is offline
external usenet poster
 
Posts: 2
Default excel VBA set array controls

I need to address with a variable a large array of User Form Command Buttons

Dim Mybutton(5) As CommandButton

Set Mybutton(1) = CommandButton1
Set Mybutton(2) = CommandButton2
Set Mybutton(3) = CommandButton3
Set Mybutton(4) = CommandButton4
Set Mybutton(5) = CommandButton5
and so on........

so later I can use Mybutton(x).caption = "whatever"

Surly there is a way to set the array with something like.

for x = 1 to 100
Set Mybutton(x)= CommandButton & (x)
next x