J
Jason
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
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