Forum Discussion
Error?
adavis726 What are you trying to achieve?
Did you step through the code with F8 and see what gets evaluated? As far as I see it, the code does the following:
if a cell in the range contains data validation and the previous value of the cell was not a blank or the current value, then the current value of the cell gets appended to the old value.
This works fine in my tests with the code as you posted it. If it does not work for you, step through the code to identify where your expectations and the code don't match.
IngeborgHawighorst I have a column which indicates what services a client accepts. The column links to a drop down list on sheet 2. I am wanting to be able to select multiple items from the drop down list.
adavis726 That does not really help troubleshoot the problem. If you expect the code to do something, but it doesn't do what you expect, you can step through the code with F8 to see which IF branch is executed. Then you know where things go "wrong" and you can inspect the value that is the condition of the IF branch.
Maybe someone inserted a column. That would cause the macro to fail, because it is now watching the wrong columns.
That sort of thing.
If you can't do these checks yourself, you will need to upload a sample file that shows the problem.
