Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Variable

Variable

ResolvedVersion 2003

Thu 14 Aug 2008, 16:59 Delegate Eva said...

Eva has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Variable

What is variable?

Tue 26 Aug 2008, 09:36 Trainer Carlos said...

RE: Variable

Hi Eva

A variable is a name used to represent a value. It is used to hold temporary values needed in the running of the VBA code.

A variable name identifies a unique location in memory where a value may be stored temporarily

The syntax is Dim VariableName As Type eg

Dim UserName as String

Regards

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Variable

Variable

RE: Variable

Excel articles

Excel tip:

New Normal Worksheet