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

Variables

ResolvedVersion 2003

Mon 20 Jul 2009, 13:46 Delegate Vishal said...

Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course

Variables

Please explain how you can view a list of all user defined variables within a project.

Fri 24 Jul 2009, 11:49 Trainer Stephen said...

RE: Variables

Hi Vishal
Thank you for your question

The quickest way to view all the variables in a procedure is to use the locals window. This lists all procedure level variables, as well as variables declared at modular and public levels. In addition, as the code runs in break mode it displays the changing values of these variables.

Hope this is useful

Regards

Stephen

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:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Variables

Variables

RE: Variables

Excel articles

Excel tip:

Sorting List Subtotals