Hi all, I've been working on a new workbook for my wife to record her sales and expenses throughout the year. The VBA elements are pretty basic and ultimately the workbook is only going to be used by her.
I've been doing the final testing on all the forms and code to tidy it all up and remove any test code used whilst building it and just noticed I have missed off Option Explicit on most of the modules, question is do I really need to use it as the code all works fine without it.
I know why is used and may just add it in as I go through the various modules anyway but just wanted to get your thoughts on using it or not.
Thanks Paul
I've been doing the final testing on all the forms and code to tidy it all up and remove any test code used whilst building it and just noticed I have missed off Option Explicit on most of the modules, question is do I really need to use it as the code all works fine without it.
I know why is used and may just add it in as I go through the various modules anyway but just wanted to get your thoughts on using it or not.
Thanks Paul