Multi select listbox code not working when 2 listboxes on sheet

**excel_vb** · 07-01-2010, 06:07 PM

Hi,

I want a sheet which has 2 multi-select listboxes. Both listboxes have seperate information and I want the user to be able to select more than option from the drop-down.
I found this code online and it works beautifully when I have 1 listbox.

Please Login or Register  to view this content.

How can alter this code so it applies to another listbox in column 10 ?
If I copy this code again replacing column 12 with 10 and variable 'z' with 'x', it doesnt work.
I end up having only 1 listbox in one column, even though I created a second listbox with different drop down values.
Any help would be most appreciated!

**davesexcel** · 07-01-2010, 06:45 PM

You can Target two Columns, something like...

Please Login or Register  to view this content.

**excel_vb** · 07-02-2010, 10:07 AM

Thanks for the quick response! But that makes the same information appear in both the listboxes.
I want 2 seperate listboxes.
For example, listbox in column 10 will have a dropdown containing ' NY, Chicago, Dallas, Atlanta' and listbox in column 12 will have ' Tennis, Chess, Football, Baseball'.

**royUK** · 07-02-2010, 10:12 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**excel_vb** · 07-06-2010, 01:30 PM

I've attached a dummy file.
I want lisboxes in column C and D wherein I can select more than option from the drop down.
Currently, the listbox works in only column D.
I want a multi-select listbox in column C which will allow me to select multiple cities just like column D allows me to select multiple games.
The code currently seems to recognize the last created listbox only.

**excel_vb** · 07-07-2010, 10:13 AM

Please let me know if I can provide any further info.
I've attached a dummy worksheet in my previous post to show what the code is currently doing. I want it to allow me to have 2 multi-select listboxes.