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

excel vba

ResolvedVersion 2003

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

Excel vba

What is a variable?

RE: excel vba

Hi Jessica

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 Reply As Byte

Hope this helps

Carlos

Wed 11 Feb 2009: Automatically marked as resolved.

 

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:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

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.09 secs.