HELP - Combining the functionalities of two codes

[Boris_L]

Hi,

I wanted to combine the functionalities of two codes that i found over the internet. I am not a VBA coder, so I'm unable to do it myself. I would be very grateful if anyone could help. I've pasted the codes below - (source: www.contextures.com)

Code 1 -

Please Login or Register  to view this content.

-----------------------------------------------------------------------

Code 2 -

Please Login or Register  to view this content.

---------------------------------------------------------------------

[pjwhitfield]

What exactly do the two Subs do? Its never straight forward to just merge two subs as there can be conflicts between IF statements etc.

[Boris_L]

Both code lets the user select multiple values from a data validation list in the same cell.

Code 1 - It also lets the user remove a value when the user clicks on the value "again" from the list.

Code 2 - It also lets the user double click on the cell and enter a value, *without creating a duplicate of the entire string* (In code 1, if i allow users to enter their own data apart form the validation list, it creates and copy of the new string, adds to the end of the old string and the combined new string gets entered)

I hope I'm able to make it clear.

[pjwhitfield]

So in its most basic form you want the functionality in Code 1 with the addition of of letting the user "double click on the cell and enter a value, *without creating a duplicate of the entire string"?

[Boris_L]

Yes, Exactly.

The main requirement is -
"Being able to select multiple items/values from a data validation list and the value gets stored in the same cell. With each item/value separated by a comma as the user keeps selecting new items/values"

With the following conditions -
1. User must be able to remove a specific value and must not require clearing the entire cell
2. User must also be able to manually enter values by double clicking on the cell. It should not result in a copy of the values getting generated again
3. Items/values must NOT repeat once the user has already selected it

In case there is a better way/technique of fulfilling the requirement without using VBA or data validation list, I'm always open to suggestions.

[AliGW]

@Boris_L - your opening post did not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

I have done it for you this time, but in future, please do it yourself. Thanks!

Also, please don't quote other posts unnecessarily.