Option Explicit - To use or not.

[Pacman52]

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

 

[Edgar_]

To anyone new to VBA:
Use Option Explicit, in fact, set that as default.

1. Weakly typed languages have a place, but VBA won't ever be updated again, it comes as is. Bugs and everything.
2. You WILL find issues without Option Explicit and they will be easy to solve once you turn on Option Explicit.
3. When you encounter an issue that has something to do with types, and trust me, you WILL, you want to have control over that, you do not want to let the compiler choose for you. The guys who made VBA are not perfect, their software has bugs and VBA won't be updated to fix those bugs.
4. Declaring your types does not necessarily mean declaring everything at the top, you can declare your variables when you need them to avoid having orphan variables later or forgetting what their type was.