asked on

Multi Select Drop Down List in Excel 2010

I'm using Excel 2010 and currenlty have an ActiveX drop down list set up via the develop tool box. Hwoever I don't see an option for multi select (I thought there was a field

ASKER CERTIFIED SOLUTION

NBVC

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

endurance

ASKER

Yep, it was listbox - I see the option.
Though although I set the linkedcell field - to a a cell in the .xls ='Sheet1'!I10
but even after selecting values in teh listbox - nothing shows in cell I10.
any idea.

thx!

SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

endurance

ASKER

Thanks, I'm not able to use code to retrieve the selections using the code referenced.
I've attached a simple .xls with an ActiveX listbox, in it is the code refererenced, and also a simple 1 line macro ("test1") which attempts to return the count of the options in the listbox.
However, when I go to run the macro it returns "Error 400"
what code is needed?

thanks
Test-ActiveX-Listbox.xlsm

Patrick Matthews

The code on that link I provided is for Forms listboxes, not ActiveX listboxes.

I recommend staying far away from embedded ActiveX controls in your worksheets. They simply do not behave as well as the Forms controls do.

endurance

ASKER

If I use the non-ActiveX listbox - how would I retrieve the values selected - on a multi select listbox.
I don't see how to use VBA with a non ACtiveX listbox (see attached) and the testListbox macro

endurance

ASKER

any info - how to use VBA to acess non -Active X listbox info (e.g. Listcount, selections)?
thx

endurance

ASKER

I'll post this as a new Q - not under the current multilist heading.