If I were to have 10 commands: invest1, invest2, invest3, etc.
How could I run these through a loop to say, change their visibility?
[VBA]
for i = 1 to 10
cmdInvest & i.Visible = False
next i
[/VBA]
Looks pretty amateur..
If I were to have 10 commands: invest1, invest2, invest3, etc.
How could I run these through a loop to say, change their visibility?
[VBA]
for i = 1 to 10
cmdInvest & i.Visible = False
next i
[/VBA]
Looks pretty amateur..
[vba]
For i = 1 To 10
activesheet.Buttons("Invest" & i).Visible = False
Next i [/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber