do i have options for the user to select multiple choices other than a listbox...?

???

thank you.

Yes, check out the properties of the listbox. there is one called MultiSelect.

You want to set yours to either the 2nd or 3rd setting.

The ComboBox should have a multivalue select option when used with a MultiValue field, and with a datasheet subform you can do multiple record selection as well.

hth

Misjuckas, are you asking about Excel or Access?

Ugh, I did it again... why do I always fail to look at the board and assume it's Access we're talking about?

Please disregard my previous post. Sorry...

Ha - I stil learned something though, and you can't take that away from me! LOL - JK

excel 2010 (and on a userform)

thanks...

ok, then see my first reply.

thank you...

?and any other options...?

thanks.

multiple checkboxes or radio buttons maybe?