Listbox - fatal error

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