Intro to Excel 2013 Macros and Form Controls

Do more with Excel Macros and Form controls
2.8 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
11 students enrolled
25% off
Take This Course
  • Lectures 21
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

This course is an introduction to Excel Macros and Form controls. The course is designed for those with some experience using Excel and now want to start using Macros and form controls in their spreadsheets. The course has three main parts, first part is all about working with and running macros, in this part you will learn how to record Macros work with and run Macros. You will learn the difference between absolute and relative references when recording your Macros and many other things you can do with Macros. The second part has to do with excel Form controls, you will learn the nine Form controls you can insert into your spreadsheets and how to define their properties to collect and work with data. The last part is us using what we have learned to create an order form application using excel formulas, form controls and macros.

What are the requirements?

  • You will need Excel 2010 or 2013

What am I going to get from this course?

  • Record and run Macros
  • Assign Macros to different Objects in Excel
  • Learn the difference between absolute and relative references in Excel
  • Learn about the nine Form controls
  • Insert Form controls and define their properties

Who is the target audience?

  • This course is designed for someone with some experience in Excel who wants to start using Excel Macros and Form controls

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Overview
Section 2: Creating And Modifying Macros
Two things you must do before you begin creating excel macros
Creating Your First Macro
Examining Macro Code
The Difference Between Absolute And Relative References
Macro Security
Assigning A Keystroke To A Macro
Running a Macro When You Open a Workbook
Assigning Macros to Shapes and Objects
Adding Macros to The Excel Ribbon
Add Macro Button to the quick access toolbar
Section 3: Form Controls
What are the nine Form controls
Inserting a Command Button
Inserting a Combo Box
Inserting a List Box
Inserting Check boxes and Option buttons
Inserting a Scroll Bar
Inserting a spin button
Section 4: Putting it all together
Creating an order form Part 1
Creating an order form part 2
Creating an order form part 3

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bobson St. Pierre, Excel VBA Programmer & Certified Microsoft Office Specialist

My name is Bobson St. Pierre I am a Certified Microsoft Office Specialist and have over 14 years of experience in the IT field. I have worked as an Excel VBA programmer, Ms Office Support Specialist, Consultant, and now Trainer. I want to take what I know about Excel and Microsoft Office and share it with you.

Ready to start learning?
Take This Course