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

variable

ResolvedVersion 2007

David has attended:
Excel VBA Intro Intermediate course

Variable

What is a Variable?

RE: Variable

Hi David

Thanks for your question

A variable is an area of memory used to store a piece of data.

When a value is passed to a procedure, either via keyboard or as the result of a calculation, it must be stored in a variable. Before passing a value to a variable it is essential that the variable is first "declared". At this point the type of data that the variable will accept is also specified, e.g.

 Dim MyVariable as string"


This creates a variable that will take string data.

Regards

Stephen

Thu 22 Jul 2010: 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:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

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.