98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
Tue 4 Nov 2008, 16:09Delegate Pamela said...
Pamela has attended:
Excel VBA Intro Intermediate course
VBA
How to identify when to use variables?
Mon 10 Nov 2008, 10:38Trainer Carlos said...
RE: VBA
Hi Pamela
Variables are names used to represent values that may change during the procedure and identify a unique location in memory.
As a basic yardstick any time you ask the user to input any data or to select an option this should be stored in a variable.
Anothere use of variables is to store results of calculations.
The syntax is Dim/Public/Private VariableName [As type]. eg:
Dim Reply As Byte
Hope this helps
Carlos
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. |
Excel tip:View a unique listYou have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column. |
