The listbox control can cause a fatal error, which cannot be catched using UnhandledExceptions .
What I did:
- editable cell , enter data
- move to next cell on
- validate the value of the just edited cell by checking with a databae and show msgbox when invalid
- if invalid, go back to the just edited cell
- boom …
How solved:
- validate the iBEFORE moving to the next cell and AVOID MORE THAN ONE CELL-MOVE within the Keydown event