vba courses london - List of variables

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

Resolved · Low Priority · Version Standard

List of variables

Marie has attended:
Excel VBA course

by - delegate Marie [3 posts] (2007 Feb 23 Fri, 15:59) Reply

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)

Excel VBA varibles

by - trainer David gold contributer [428 posts] (2007 Mar 1 Thu, 17:08) Reply

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

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

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips