hi
18 different categories. oboy.
1. combo boxes do not support multisect.
2. check boxes. you would have to code if then else/select case statements
for all of the possible mathmatical combinations for 18 different check
boxes. whoa. i didn't do the math but .....personal opinion. i wouldn't go
there if i were you.
3. list boxes do have multilsect properties so i think that would be the way
to go.
user form tutorial. see this site.
http://contextures.com/xlUserForm01.html
unfortunially it does not cover llist boxes but does give general info.
i did search my liberary but it seem i don't have much on excel forms and
list boxes so my liberary seem to be lacking. sorry. do a google. good luck.
regards
FSt1
"Ivor Davies" wrote:
I have a list containing 18 different categories. I want to create a user
form that allows the user to select multiple combinations of these categories
- either through a check box or list box (prefer check boxes). Once the
selection is complete the choices made will be recorded as data in a separate
list in the worksheet.
I am using Excel 2003, I have not created user forms before and have only
basic experience with VBA coding. Is there a step-by-step guide somewhere
that will show me how to create a user form that includes check box options?