98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Writing Code lines
Writing Code lines
Resolved · Low Priority · Version 2003
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |
