Next you need to learn to debug. Did you know you can set breakpoints, monitor variables in the Watch window, single step through code, ...?

Much easier than all those MsgBox statements.