Excel - Create an Excel User Form

Introduction to UserForms

Set up the worksheet 

Create a UserForm

Name the UserForm

Add a Textbox to the UserForm

Add a Label to the UserForm

Add remaining textboxes and labels

Add Buttons to the UserForm

Add code to the buttons

Test the UserForm

Create a Button to open the UserForm

Finish the Workbook

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Create Dependent Lists With INDEX

Create Dependent Lists With INDEX

Create Named Lists

Create the Dynamic Ranges

Setup the Validation cells for Column A on Data Entry

Setup the Validation cells for all other columns on Data Entry

The finished Data Entry sheet with sample Data

Expanding Columns on sheet Lists

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Excel - Create Dynamic Ranges With a Macro

Create Dynamic Ranges With a Macro

Set up the workbook

Create the Dynamic Range for number of rows

Create a Dynamic Range for YearMth column

Create a Dynamic Range for the Region column

Create Dynamic Ranges with a macro

Use Dynamic Ranges in Formulas

Use Dynamic Ranges in Pivot Tables

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London