Name: Visual Basic of Applications: Become Excel VBA Programmer
Rating: 4.1 (39 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byManoj Kumar

Last updated 6/2016

English

What you'll learn

Over 35 Lectures and 3 Hours of Video Content
Learn to Record, Write and Dubug Basic and Semi Adv. Macro
Learn the use of Inputbox, Do....Loop, Do while and Do Until, For.....Next
Writing Personal Macro, Worksheet and Workbook Events, VB Protection
Userforms, Define short cut key, Defined Functions, Error handing, break points
Learn the best way to use Range, Cells and Offset to access the cells

Course content

9 sections • 45 lectures • 3h 59m total length

Introduction to the Course Contents3:15

Introducing Macro5:04
A simple example will show the Power of Macro how fast it can work.
Record Your First Macro6:23
Learn to record Excel event in VBA coding through Record Macro and define short cut key.
Enter Data In Same Worksheet7:21
This is the first macro (VBA coding) to enter data in active worksheet.
Enter Data In Inter Work Sheet3:39
Learn how to enter data in any specific worksheet.
Insert Coment to a Macro2:19
How to insert a description in a macro .
Saving An Macro Enabled File1:30
Saving a macro file is different then a normal excel file. Learn how to save a macro enabled file.
Dealing With Macro Security1:29
Enable and disable macros in Excel.
Use Of Input Box And Formula Comand8:09
Use of useful command in VBA in Input box. Lets see how can we make the macro inteactive with Input box.
Use Of Inputbox, Msgbox, Formula In Different Way7:18
Interact with user and make Macro dynamic while entering data in excel worksheet.
Inserting Camand Button And Assigning Short Cut Key5:28
Make a button in Excel sheet and link it to a particular Macro, so that you can run it by clicking on that Button only.
Personal Macro Workbook3:07
Learn how to make any macro available in every excel workbook through Personal Macro workbook.
How to delete a Personal macro and Personal Macro Workbook3:15
How to delete any macro which is personal and available in every workbook.

Multiple ways to Enter Date in Excell with Cell, Range and Variable3:15
Learn alternative ways to enter data in Excel with VBA coding
Work with Data Fonts with Cells Properties1:52
Cut And Paste Data From One Sheet To Another Sheet5:50
Transfer data from one worksheet to another worksheet automatically.
Break Points And Call Command5:48
How to control the running macro on its way with Break Points and link one macro with another macro with Call command.
Worksheet Related Commands: Select, Add, Rename And Delete Worksheet7:16
Some basic worksheet commands to select, rename, add, delete
Copy Data To Sheet3 With Variables7:52
How to copy data from one Excel sheet to another
How To Handle The Error15:52
How to manage the error with VBA commands.

Use offset to put values7:26
Frequently used and Advance VBA command is offset. You will use in at various VBA coding.
Assign Result Based On Marks Using If, Offset And For----next Command6:46
Assign Grades Based On Marks Using If, Offset And For----next Command5:35
Select Case an Alternative to IF Function in VBA8:57
Use Of Do While And Do Until............loop7:12
Use Of Formula Command With For.........Next5:41
Use Of Vbyesno On Msgbxo To Provide Flexibility5:31
A combined Use Of Do While & For Next to enter details in Excel13:23
Define a Fucntion which is not Pre-Defined in Excel8:55

Introducing Events Activte & Deactivate Events3:38
Events are powerful properties in VBA. They trigger macro when any specific event occurs. Learn how to trigger a macro automatically when you activate or deactivate a worksheet in Excel.
Autofit Column Width with Change Event4:10
Learn how to automatically adjust the column width when you add data in worksheet in Excel
Workbook Opening & Closing Events2:45
Run a macro when you open or close a workbook.

Requirements

You should have at least beginner level knowledge of Excel

Description

In this course, Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.

You will first learn how to record a Basic macro, how to define Short cut key, how to debug and run macros. Once you are comfortable with VBA environment, we will cover most frequently used commands like Do while, For Next, Input box, Userform, Workbook and worksheet Events. At last we shall take many practical long problems to advance your knowledge on VBA.

The best way to learn Macro is to learn it with case studies. With case studies, you develop your creativity. You will learn multiple ways to write a program with different coding.

Once you learn VBA, the task that you do in several hours, you will be able to complete that in just few seconds. You will be able to perform even that task which is not possible with Only Excel.

Who this course is for:

One who want to make full use of Excel and solve problems which is beyond the Excel.
Anyone who wants to learn how to write VBA in a professoinal environment
Anyone who wants to add weight to resume and value to their current or potential employer

What you'll learn

Explore related topics

Course content

Getting Started1 lecture • 3min

Introducing VBA and Record first Macro12 lectures • 55min

Do some basic Calculations Using VBA3 lectures • 8min

VBA Commands and Properties7 lectures • 38min

Use of Excel Formulas and Take some Practical Examples9 lectures • 1hr 9min

Create Events in Macro to run Program Automatically3 lectures • 11min

Managing Data through Userform5 lectures • 16min

Case Study: Rearrange Data with Macro3 lectures • 16min

Transfer data from One Workbook or one worksheet to another Master workbook2 lectures • 23min

Requirements

Description

Who this course is for: