Recording Macro

The UK's most regular instructor-led training courses.
Training information: excel course · Excel courses london · VBA courses London UK

Resolved · Low Priority · Version 2003

Recording Macro

Akiko has attended:
Excel VBA course

by - delegate Akiko [1 post] (2008 Jul 3 Thu, 16:44) Reply

I am not sure exactly when I should use “Dim” or “Public”.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

Variable Scope Dim vs Public

by - trainer Carlos gold contributer [479 posts] (2008 Jul 24 Thu, 12:11) Edited on 2008 Jul 24 Thu, 12:12 Reply

Hi Akiko

If you declare a variable as Dim it sets it up to be seen only by the procedure or module that contains it. For example:

Sub Test()

Dim MyName as String

MyName = "Carlos"

End Sub

If I wanted to access the value of MyName from another procedure it wouldn't find it.

So if the variable you are declaring needs to be accessible by all procedures and modules in a project then it needs to be declared as Public. For example:

Public MyName as String

Hope this helps

Carlos

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· A Beginners Guide To Formulas In Excel
· Why Should I Learn Visual Basic in Excel?
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Excel in the Home Office

Please browse our web site to find out more about
excel course and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips

Rate this page: