Creating Excel 2007 multiple selection drop-downs

[yellowbooks]

Hi
I need to create a multiple selection drop-down in Excel. So, data validation is out and I will have to use a form control, an Active X one. List boxes only allow single selection and the Combo box is too 'big'. I need the box itself to only take up one cell as the sheet is large (it is a survey form) with many questions. I have NO knowledge of Active X/ VBA so I would struggle to 'fiddle' with the code. Any suggestions?

Many thanks in advance.

 

[bradhog]

Even i'm additionally facing identical drawback.

I have tried with the answer you have got urged like ListFillRange=’Sheet1’!A1:A5 (A1:A5 is simply for instance, please fill it together with your own range), MutiSelect=fmMutiSelectMuti, ListStyle=fmListStyleOption.

But I currently i need to show the chosen things within the stand out as there's just one choice left with the connected cell.

When I tried to link cell with the vary Sheet1’!B1:B5 it's not displaying with the things elite within the dropdown.

If you find any answer to this please share.

 

[yellowbooks]

Hi
I am still searching for answers. But it's clear this is going to be a problem. The scrolling doesn't work for me; I need a drop-down list. Customers just won't scroll through a list.

I'm not quite sure what your problem is. Is it about identifying the range? I find it's easier to create a named range, e.g. ListFillRange =yournamedrange. Set that up under Formulas.

Regards