Prevent VBA from duplicating dropdown list selections when entering manual text.

Hi everyone:

I'm using a VBA code for a dropdown list with multiple options in Excel, but when I enter text manually in a cell that already contains one or more selected options, the code duplicates the previous selections and then adding the new text. For example, if I select "Option 1" and "Option 2" from the dropdown list, the cell displays "Option 1, Option 2". However, if I then type "text" in the same cell and click on another cell, the cell displays "Option 1, Option 2, Option 1, Option 2, text".

I'd like to modify the code to prevent this behavior and maintaining the selections Option 1, Option 2 with the new text when the cell is edited manually. Here's the current code I'm using:

Please Login or Register  to view this content.

Can anyone help me modify this code to achieve the desired behavior? Thanks in advance for your help!

Hello everyone,

I recently posted a question regarding a VBA code issue with dropdown lists in Excel that was causing duplicate selections when entering text manually. I haven't received any answers yet and wanted to let you know that, in accordance with the forum rules, I have posted the same question in another forum. Here's the link: https://forum.ozgrid.com/forum/index...g-manual-text/.

I apologize for any inconvenience this may cause and I appreciate any help or suggestions you can provide.

Thank you!