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 » excel consultant - Variables
excel consultant - Variables
Resolved · Low Priority · Version Standard
Thu 2 Aug 2007, 16:42Delegate Jacky said...
Jacky has attended:
Excel VBA Intro Intermediate course
Variables
how do you create a variable?
Mon 6 Aug 2007, 15:50Trainer Carlos said...
RE: Variables
Jacky
A variable needs to be declared before it can be used. To do this:
Dim/Public <variablename> as <type>
eg
Dim Area as Single
Public UserName as String
Regards
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:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |
