best training excel intermediate - variables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Karen has attended:
Excel VBA Intro Intermediate course

Variables

How do you define a variable

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:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Server loaded in 0.09 secs.