Option Explicit function and private/public/dim

[larryg003]

What is the difference between code that has the words Option Explicit written at the top and code that does not have Option Explicit written at the top?

Also, what is the difference between declaring a variable as

Please Login or Register  to view this content.

What is the difference between using public/private/dim.

Thank you for all of your help,

[Marcol]

In a VBa module

Highlight Option Explicit then press f1

Same for Sub

These help files contain a mine of information and in VBa they are more informative than many I can think of!

Use this method for any function you need to know about!

[shg]

See VBE Help for Declaring Variables, Understanding Scope and Visibility, and Understanding the Lifetime of Variables.