The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Variable

Resolved · Low Priority · Version 2007

ReplyWed 14 Jul 2010, 16:01Delegate David said...

Variable

What is a Variable?

For upcoming training course dates see: Pricing & availability

ReplyThu 15 Jul 2010, 14:18Trainer Stephen said...

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.

Excel articles

· How To Disguise Error Messages In Excel 2007/2010
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Tips To Help You Excel
· Want To Get To Grips With The Different SUM Functions In Excel?
· Excel in the Home Office

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

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Hello
I have an email signature. When I use it with a new message, its fine. But when I forward the line spacing changes (increases). How can I stop this happening please?

» Forum post: Signature/line spacing

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions