variables

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Variables

Variables

resolvedResolved · Low Priority · Version Standard

Wendy has attended:
Excel VBA Intro Intermediate course

Variables

What is the difference between a variant and a variable

RE: Variables

Hi Wendy

Thankyou for your question

A variable is anything that you define at the start of a module or procedure, the value of which will vary throughout the execution of your code.

Variables can be of a range of different types which specify the type of data they can hold. String variables can hold text and numbers, while Byte can only hold numbers in the range 0-255.

Variant is a type of variable. It is a catch all and can hold numeric as well as text and date data.

Hope this is useful

Regards

Stephen

 

Training courses

 

Training information:

See also:

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:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips


Server loaded in 0.09 secs.