Ioniya Macros Vba Excel

  1. Home
  2. Excel-vba
  3. Ioniya Macros Vba Excel

Tags: Excel VBA

A well designed course to learn Macros and Visual Basics for Applications in Excel

Last updated 2022-01-10 | 4.6

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

What you'll learn

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

* Requirements

* Microsoft excel 2010

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.

Who this course is for:

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

Course content

8 sections • 47 lectures

Introduction 1 lectures

Introduction to VBA Preview 02:54

Recording a Macro 2 lectures

Getting started Preview 01:51

Recording first Macro Preview 04:47

Objects in VBA 11 lectures

Overview Preview 04:37

Object under project Preview 06:20

Worksheet object Preview 05:44

Rows and columns Preview 05:12

Cell object Preview 04:31

Range object Preview 06:00

Properties and range Preview 05:52

Properties and method Preview 04:02

Dates Preview 04:00

Working with color Preview 07:13

Variables Preview 05:41

Various boxes and functions in VBA 19 lectures

Message box Preview 06:41

Input box Preview 05:25

Button Preview 02:44

If then Preview 09:40

With .. end with Preview 04:48

Case Preview 09:23

For Preview 07:11

Do loop Preview 07:08

Logical operator Preview 08:29

User defined functions Preview 04:48

Event handling Preview 04:04

Copy and paste Preview 03:31

Conventions Preview 07:15

Array Preview 05:01

Importing data Preview 05:03

Calculator Preview 02:44

CountA function Preview 02:58

For each loop Preview 02:20

Password protection Preview 04:19

Userforms 3 lectures

Userform Preview 07:36

Forms and label Preview 08:00

Creating a userform Preview 04:47

More features 9 lectures

Text box Preview 09:56

List box Preview 06:58

Combobox Preview 05:52

Checkbox Preview 07:05

Option button Preview 05:21

Command button Preview 03:59

Multipage Preview 04:12

Image Preview 02:57

Export and Import Preview 03:04

Conclusion 1 lectures

Conclusion Preview 00:07

All Exercise files 1 lectures

Exercise files Preview 00:01