Data Validation scuppering macro

hi folks,

i am working on providing a VBA-based solution for this thread:

http://www.excelforum.com/showthread...=1#post2868374

i hit upon an issue which i am just not able to figure out how to solve.

the spreadsheet has a column of Data Validation cells (column F). if i were to type a value in every cell along a row and hit TAB (or the arrow keys), as soon as i reach column F, excel craps out. i have pop-up messages about "not enough resources" and i have no option but to End Task excel through Task Manager.

i do not have this experience if i hit enter after entering values, just when TAB or arrow keys.

please see if you can help. if you update the original thread, that would be great, too.

Hello icestationzbra ,

You should also include a link to this post in your post in the General forum and attach a copy of the latest workbook to this thread.

leith, here you go...

When writing into a sheet where a Worksheet_Change macro is triggered by such actions, be sure to turn off events so as to no self-trigger. Maybe these suggested changes, this version will work even if multiple cells are changed at once, as might happen with a copy/paste:

Please Login or Register  to view this content.

hi jerry,

thank you very much - i have tested and this code seems to have fixed the problem. i really appreciate your help.

i will pass this onto the original OP and just let the OP test once or twice to see that everything is working fine at their end, too.

best regards.

rmcc, please switch to your original thread...