VBA stopped working!!

**maxthebear** · 02-18-2009, 05:45 PM

Yesterday I received great help from everyone on the code below. It worked perfectly allowing me to select more than one item in a drop down.

Today it stopped working. I had copied the file with a new name and changed the target column to 14 (Column N) and it did not work.

I went back to the original file with column 10 and it does not work either. Any ideas would be appreciated.....thanks again Max
-----------------------------------------------------

Please Login or Register  to view this content.

**shg** · 02-18-2009, 07:00 PM

It only works for cells in col 14 that have data validation.

You also took out the test for target.count > 1, which will result in a runtime error if multiple cells with validation are changed simultaneously.

**maxthebear** · 02-18-2009, 07:31 PM

Thank you. Where exactly would the target.count >1 go in the code along with the target column <> 14. thanks much.

Max

**maxthebear** · 02-18-2009, 08:04 PM

OK how does this look?? It still doesn't seem to work...I made column N a validation...

Please Login or Register  to view this content.

**shg** · 02-18-2009, 09:13 PM

Does the cell you're changing have validation?

Have you closed and reopened Excel to make sure events are enabled?

If yes to both of the above, post the workbook again, Max.