Macros & VBA Excel

A well designed course to learn Macros and Visual Basics for Applications in Excel
4.3 (1,189 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.
13,365 students enrolled
Free
Start Learning Now
  • Lectures 47
  • Length 4 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 11/2013 English

Course Description

This course is an Introduction to VBA & Macros in excel.

In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs.

As always, to make things easier we have included links to download Exercise files as well as the results for each topic.

What are the requirements?

  • Microsoft excel 2010

What am I going to get from this course?

  • By the end of this course, you will be able to write programs to customise Excel.

What is the target audience?

  • Some knowledge of excel and its features will make it easier for you to follow this course

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.

Curriculum

Section 1: Introduction
Introduction to VBA
02:54
Exercise files
Article
Section 2: Recording a Macro
Getting started
01:51
Recording first Macro
04:47
Section 3: Objects in VBA
Overview
04:37
Object under project
06:20
Worksheet object
05:44
Rows and columns
05:12
Cell object
04:31
Range object
06:00
Properties and range
05:52
Properties and method
04:02
Dates
04:00
Working with color
07:13
Variables
05:41
Section 4: Various boxes and functions in VBA
Message box
06:41
Input box
05:25
Button
02:44
If then
09:40
With .. end with
04:48
Case
09:23
For
07:11
Do loop
07:08
Logical operator
08:29
User defined functions
04:48
Event handling
04:04
Copy and paste
03:31
Conventions
07:15
Array
05:01
Importing data
05:03
Calculator
02:44
CountA function
02:58
For each loop
02:20
Password protection
04:19
Section 5: Userforms
Userform
07:36
Forms and label
08:00
Creating a userform
04:47
Section 6: More features
Text box
09:56
List box
06:58
Combobox
05:52
Checkbox
07:05
Option button
05:21
Command button
03:59
Multipage
04:12
Image
02:57
Export and Import
03:04
Section 7: Conclusion
Conclusion
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ioniya ., When you know better, You Do better !!

Ioniya is a video publishing company based in india. Ioniya has created a platform which is trying to bridge the gap between the students and the industries. Authors who have wide knowledge in their fields, help us design our courses which are very practical. We, are an organisation moulding software learning skills to professionals and students bridging the gap between industry specific needs and efficient working. We build the digital literates. We provide an effective method through simulation, a teaching which is very effective and consumes very little time. Ioniya builds an ecosystem in which the learners have a knowledgeable experience in learning from us.

We started with video tutorials for Microsoft office and Engineering softwares like Autocad. We are working on tutorials for many other softwares like Tally, Catia, Weblogic and languages like java,.net etc. With the help of a platform like Udemy, we hope to spread this ocean of knowledge throughout the world.

Ready to start learning?
Start Learning Now