Thu 3 Jul 2008, 16:45Delegate Erika said...
Erika has attended:
Excel VBA Intro Intermediate course
Writing Code lines
When do you use Public as a String instead of Dim?
Thu 24 Jul 2008, 11:55Trainer Carlos said...
Dim vs Public in Variable declaration
Hi Erika
When declaring variables you use the Public setting when you want the variable to be seen and be accessible by all procedures and modules in a project (eg Forms).
A Dim declaration sets the variable to be seen only by the procedure or module that contains it.
Hope this helps
Carlos
