vba training london - Variable and Varient

The UK's most regular instructor-led training courses.
Training information: vba training london · Excel london

Resolved · Low Priority · Version Standard

Variable and Varient

Thomas has attended:
Excel VBA course
Excel Advanced course

by - delegate Thomas [2 posts] (2007 Jun 21 Thu, 09:53) Reply

What is the difference between a variable and a varient?

RE: Variable and Varient

by - trainer Carlos gold contributer [391 posts] (2007 Jul 2 Mon, 10:11) Reply

Hi Thomas

A Variable is a place to store a piece of information in the computer's memory.

Just as you might store a person's telephone number in your memory, you can store information in a computer's memory. Variables are a way of accessing the computer's memory and setting aside memory space to store the information.

A Variant is essentially a universal data type.

It can contain any kind of information internally, and represent any data type

Regards

Carlos

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips