Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - List of variables
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - List of variables
Resolved · Low Priority · Version Standard
Reply Fri 23 Feb 2007, 15:59Delegate 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)
For upcoming training course dates see: Pricing & availability
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
|