View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default [HELP] How to use command buttons in cycles

Something like:

Dim v as MSForms.Commandbutton
redim v(1 to 30)
for i = 1 to 30
set v(i) = Userform1.Controls("Commandbutton" & i)
Next

--
Regards,
Tom Ogilvy


"C.F." wrote in message
...
for i = 1 to 30
userform1.Controls("CommandButton" & i).Caption = _
Range("A" & i).Value
Next i



really thanks.

i've another quick question:

if i would declare an array of command buttons how i should
do that??

again thank for your answer you've solved me a lot of
problems!