'Onedit' too slow and useless

Hello,
I am using the Onedit trigger in a code to block the modification of cells in a column if the value is not correct. If I change a value slowly and wait for the program is finished, it works fine.

But, if I change 3 cells very quickly, the program only done the test on the first modified cell. Cells that were modified while the code was running are not blocked.

How to make the Onedit function run well on each modified cell one after the other?

Thank you in advance for your help.

 

0 1 390
1 REPLY 1

Suggest using a Valid_IF formula instead

Top Labels in this Space