Excel VBA

Excel VBA 1.5

See How This window allow you to directly test some VBA code. So let’s start, type the following into the console: ?Worksheets. Select .Count in the list or directly type .Cout to obtain : ?Worksheets.Count [Read More >>>]

Excel VBA

Excel VBA 1.4

See How 3: Type the following code in the new module : Sub hello()      MsgBox “Hello World !”End Sub

Excel VBA

Excel VBA 1.3

The procedure describes how to add an Object library reference, and afterwards how to declare new variables with reference to the new library class objects. The example below shows how to add the PowerPoint library [Read More >>>]

Excel VBA

Excel VBA 1.2

To explicitly declare variables in VBA, use the Dim statement, followed by the variable name and type. If a variable is used without being declared, or if no type is specified, it will be assigned the [Read More >>>]

Excel VBA

Excel VBA 1.1

Step 1: Open a Workbook Step 2 Option A: Press  Alt  +  F11 This is the standard shortcut to open the VBE. Step 2 Option B: Developer Tab –> View Code First, the Developer Tab [Read More >>>]

THE RIBBON

The Developer Tab

The Developer Tab contains a variety of tools that allow you to customize Excel. Of particular importance is the fact that the Developer tab contains tools that allow you to create, access and edit macros. [Read More >>>]

Excel Is Fun

Office 2016 01

DESCRIPTION Topics in this video: (00:01) Introduction (00:28) Programs/Apps (application software) (02:32) Task Bar (02:56) Operating Systems (03:11) Start Button (05:23) USB Flash Drive (05:58) Introduction to Windows Explorer (09:34) Deleting a File or Folder [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 26

DESCRIPTION In this video use Macro Recorder to record six Macros: (00:12) Basics for Recorded Macros (VBA) (05:55) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro [Read More >>>]

Dueling Excel

Dueling Excel 009

DESCRIPTION See Mr Excel and excelisfun take a table of data and create a column of values that can be used with the Statistical Data Analysis Excel Add-in. Mr Excel uses VBA Macro code. excelisfun [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 51

DESCRIPTION Topics in this video: 1. Macro Basics. 2. Format Variable Height Report with Absolute and Relative References. 3. Rearrange Records from Vertical Orientation to Proper Data Set with Relative References. Copy Code from Internet: [Read More >>>]