vba courses london - variable
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Variable

vba courses london - Variable

resolvedResolved · Low Priority · Version Standard

replyReply Thu 8 Mar 2007, 09:40Delegate Helen said...

Helen has attended:
Excel VBA Intro Intermediate course

Variable

What is a variable?

For upcoming training course dates see: Pricing & availability

replyReply Thu 8 Mar 2007, 12:46Trainer David said...

Excel VBA Variable

Hi Helen

I trust that you found your excel vba course useful.

A variable is basically a piece of code that allows you to assign a value, that you are able to change. You can then use the value this variable holds in other areas of your code.

for example you could create a variable called animal. Within the code you can then assign a value to it eg cat, dog, rabbit. You could then use this variable an print out the value that it holds.

Hope this helps
David

 

Vba tip:

Use GoTo to Select A Cell With VBA

To select a certain cell on a Worksheet you can use:

Application.Goto Reference:=Range("V300")

or more simply

Range("V300").Select

If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:

Application.Goto Reference:=Range("V300"), Scroll=True

View all VBA hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard