View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jen_writer jen_writer is offline
external usenet poster
 
Posts: 16
Default select more than one item in list

never mind, I just noticed the macro example from earlier has different tabs
and there is one that does exactly what I need!

"jen_writer" wrote:

Hello,
I tried to use a combo box to create a list, but after posting a question on
this site, the only info I got about selecting more than one item from the
list was to use a macro to put info in a separate cell.

I then tried the list box on the forms menu and this allows me to select
multiple items by holding down the control key. this is exactly what I
wanted. However, is there a way to make this list a drop-down list instead of
a basic list with double arrows? (I don't want to have to use more than one
cell)
thanks
Jen