To add onto what Matt wrote, I would recommend breaking your code into
smaller sub procedures, with called from the event procedure that
you're working with. It makes it much easier to test and logically
organize your program. Plus, you can write small test functions for
each sub to run independently, saving you a lot of debugging time in
the long run.

- Nick Hebb