filling a form with an array
 

I have a form that has 10 checkboxes and want to write the captions based on
an array I have previously filled. The array will change, 1 time it will
have 5 items and the next time it might have 7 or 8 and I plan on disabling
any checkbox that won't have a caption.

I'm having trouble getting started with the code. Any help would be
appreciated.

--
JT

filling a form with an array
 

a lot would depend on the particulars.


for i = 1 to 10
if arr(i) < "" then
with userform1.controls("checkBox" & i")
.Enabled = True
.Label = arr(i)
end With
else
userform1.controls("checkBox" & i).Enabled = False
end if
Next

--
Regards,
Tom Ogilvy



"JT" wrote in message
...
I have a form that has 10 checkboxes and want to write the captions based
on
an array I have previously filled. The array will change, 1 time it will
have 5 items and the next time it might have 7 or 8 and I plan on
disabling
any checkbox that won't have a caption.

I'm having trouble getting started with the code. Any help would be
appreciated.

--
JT