multiselection

[captedgar]

Hi there

On my excel sheet there are about 5 dropdown lists and the following code associated to it

For some reason, when i select a Yes from one of the dropdown list, the value gets inserted along with other values in the list box. For example: No; Yes
and also on another list box, it is omitting the first character of the value. For example: Roger Federrer is inserted as Oger Federrer

Can u please explain why this is happening as i'm trying to understand the logic behind this code

Please Login or Register  to view this content.

[Leith Ross]

Hello captedgar,

It would be easier to help you if you post the workbook.

[captedgar]

Hi Leith

I have attached a sample workbook as requested.

What i'm after is i want to insert multi selection in the cell when i select countries or people visited

For ex: If i select country as France and then decide to add Spain to the same cell, i should be able to do it. Same applies for the visited by column

I have based the example on http://www.contextures.com/DataValMultiSelect.zip