How would I create an error log that would store log data to a cell range or
a .txt file, to include: Error number, error name/description, line of
suspected erronious code and if possible some basic information about what
they did to create that error?

I am having some intermittent errors that occur in my VB code on different
machines... Because no one else at my office has any idea what I'm doing
they disregard the error and move on. Then all I get is the extremely useful
error report from them: "Your excel file doesn't work!" which is very hard to
debug!

Any help or suggestions on implementing this would be appreciated.

Thank you!

~Josh