Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - List of variables

vba courses london - List of variables

ResolvedVersion Standard

Fri 23 Feb 2007, 15:59 Delegate Marie said...

Marie has attended:
Excel VBA Intro Intermediate course

List of variables

is there any easy way of pulling out a list of all your public/private variables you've entered in your code? (so you can see what you've done without having to go into the code)

Thu 1 Mar 2007, 17:08 Trainer David said...

Excel VBA varibles

Hi Marie

As far as know there is no way to do exactly what you asked. However you can write a piece of code after each of the variables and get it to print out a useful message, ie variable name and purpose. You could get it to print out to a a form or word doc or text file or to excel itself.

Hope this helps
David

Training courses

98.7 % recommend us

More live stats...

Training information:

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

vba courses london - List of variables

List of variables

Excel VBA varibles

VBA articles

VBA tip:

Use GoTo to Select A Cell With VBA