>>Is there a way to show the line of code that the error is on in a message box?
Short answer: no. Some time ago there was a discussion in this thread about an undocumented VB function that returns a line number, but only if you really do number your lines. Maybe someone else can recall the exact details.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell