Forum Discussion
Error?
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.