Forms & Functions (Part 3 of 3)

The last video in this training covers forms & functions. At the end of this video, you will learn two practical examples. The first one is a macro to have an input box popup and then you put any column, row, or cell and it will select it automatically. The second is a function to determine whether or not a sheet exists. You will use this frequently because there isn’t a preset methodology already in Excel.

By the end of this video, you will have all the tools necessary to start writing your own macros.