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

Excel vba

ResolvedVersion 2003

Wed 4 Feb 2009, 09:26 Delegate Gemma said...

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

Excel vba

What is a Variable

Wed 4 Feb 2009, 13:36 Trainer Carlos said...

RE: excel vba

Hi Gemma

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:

Dim Counter As Integer

Hope this helps

Carlos

Wed 11 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Excel vba

Excel vba

RE: excel vba

Excel articles

Excel tip:

Use shortcut keys to select rows or columns