Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate form filling | Excel Discussion (Misc queries) | |||
Filling in a Gov't Form | Excel Discussion (Misc queries) | |||
Form Filling | Excel Discussion (Misc queries) | |||
Filling in a form from a list | Excel Discussion (Misc queries) | |||
filling a form in webpage | Excel Discussion (Misc queries) |