Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba

ResolvedVersion 2003

Ashley has attended:
Excel VBA Intro Intermediate course

VBA

What is a variable?

Variables

Hi Ashley

A Variable is a name that is used to represent a value. Variables are mainly used to represent values that are likely to change during a procedure.

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

A variable can be declared using the Dim statement as shown below:

Dim MyName As String

It is important to always indicate the data type of the variable.

Hope this helps

Carlos

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.