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:
Can anyone help me modify this code to achieve the desired behavior? Thanks in advance for your help!
Bookmarks