Creating a VBA User Form
Learning Objectives:
  1. Understand how to control Excel using VBA
  2. Be able to update and change the VBA code
  3. Test how effective your completed user form is
Resource Image Links:
  1. TES Resources - VBA Lesson: Excel Spreadsheet
  2. TES Resources - VBA Lesson: User Form Interface
  3. TES Resources - VBA Lesson: VBA Code
How to Use this Resource:

Resource Description

Differentiation Opportunities:

The level of difficulty (1-9) for completing the various tasks are provided in the link below:

TES Resources - VBA Lesson: Differentiation

Save for later
  • VBA_Lesson_Plan.docx
  • VBA_Presentation.pptx
  • VBA_Resource_Images.docx
  • VBA_Student_Workbook.xlsm
  • VBA_Student_Worksheet.docx

About this resource


Created: Jul 12, 2019

Lesson plan

docx, 26 KB



pptx, 37 KB



docx, 707 KB


Report a problem

Tes Paid Licence

How can I re-use this?