best training excel intermediate - variables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel intermediate - Variables

best training excel intermediate - Variables

resolvedResolved · Low Priority · Version Standard

replyReply Thu 6 Dec 2007, 16:37Delegate Karen said...

Karen has attended:
Excel VBA Intro Intermediate course

Variables

How do you define a variable

For upcoming training course dates see: Pricing & availability

replyReply Mon 10 Dec 2007, 09:10Trainer Carlos said...

RE: Variables

Karen

To define a variable you use the VBA word "Dim". For best practice you should also give it a Data Type. For example:

Dim MyVariable As String

The word Public can be used instead of Dim if the variable is being shared with other Modules or Forms.

Caarlos


 

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard