View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Stuffing Multiple Checkbox Captions

Sandy

For i = 1 To 2
Me.Controls("CheckBox" & i).Caption = "Test" & i
Next i

hth,

Doug

"Sandy" wrote in message
...
I have a user form with 20 check boxes. I want to loop through them
stuffing
the captions with various text retrieved from a worksheet.

The checkboxes are consecutively named checkbox1 to checkbox 20.

for i = 1 to 20 step 1

what goes here?

next i

Thanks,

Sandy