variable
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Variable

resolvedResolved · Low Priority · Version 2003

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

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

Variable

What is variable?

For upcoming training course dates see: Pricing & availability

replyReply Tue 26 Aug 2008, 09:36Trainer 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

 

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

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard