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

Carlos

ResolvedVersion 2003

Fri 30 Jan 2009, 16:46 Delegate Willem said...

Willem has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Carlos

what is a variable

Mon 2 Feb 2009, 09:38 Edited on Mon 2 Feb 2009, 10:04 Trainer Carlos said...

RE: Variable Declaration

Hi Willem

A Variable is a name used to represent a value in VBA.

They represent values that may change during the procedure and identify a unique location in memory.

The syntax is Dim/Public/Private VariableName [As type]. eg:

Public SalesPerson As String

Hope this helps

Carlos

Mon 9 Feb 2009: Automatically marked as resolved.

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:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Carlos

Carlos

RE: Variable Declaration

Excel articles

Excel tip:

Adding date and time