Visual Basic of Applications: Become Excel VBA Programmer

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

Visual Basic for application (VBA) for Excel is to automate repetitive Task, Reduce work load & unlock real Excel Power.

Created byManoj Kumar

Last updated 6/2016

English

English [Auto],

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
Learn to automate repetitive Excel tasks with macros using Visual Basic for Applications, mastering recording, debugging, basic commands, shortcuts, and user forms, then explore events and functions.

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
Learn to manipulate Excel cell fonts with VBA by setting font name and font size for worksheet data, and observe how code formats all cells to the specified style.
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
Learn to automate grade evaluation in Excel VBA by using if statements, offsetting cells, and for next loops, including dynamic input to apply results across multiple students.
Assign Grades Based On Marks Using If, Offset And For----next Command5:35
learn to assign grades in excel vba using if statements, offset, and a for next loop to process students with dynamic input and do while or do until options.
Select Case an Alternative to IF Function in VBA8:57
Learn how to use select case as a substitute for if in VBA, assigning results to cells based on conditions and handling blanks across columns.
Use Of Do While And Do Until............loop7:12
Learn to implement do while and do until loops in the Visual Basic Editor to grade students, with or without user input, looping until a blank cell is reached.
Use Of Formula Command With For.........Next5:41
Use Of Vbyesno On Msgbxo To Provide Flexibility5:31
Learn to use a message box with yes/no options to flexibly run one or both VBA programs from a single click.
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
Define a custom Excel function via macro to calculate tax from income and expenses using brackets: 30% above 10 lakh, 20% 5–10 lakh, 10% 2–5 lakh, 0% below 2 lakh.

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.

Understand First Basic Userform1:13
Use User Form to enter data in excel, do calculations and much more.
Basic Example On How To Create Userform5:42
A simple example to understand the use of User Form.
Basic Example On How To Create Userform Continued3:20
Use Of Userform Without Defining Variables1:43
Use a userform to submit data without declaring variables by writing name and salary directly to worksheet columns using offset, and run the macro to transfer values.
Use of Combobox to Provide Defined List3:47
Create a Visual Basic Editor user form that uses a defined company list in a combobox and submits employee data to Excel columns B through E.

Reconding Macro with Use Of Relative References2:47
Transpose The Data With Do While..............Loop9:15
Record a VBA macro to transpose each customer's details into adjacent columns using paste special, and automate the 400-row loop with a do while in the Visual Basic Editor.
Transpose The Data With Do While Loop Continued4:26
Learn to transpose customer details from rows to columns and remove blank rows using macros, recording steps and merging two macros into a single automation that processes all customers.

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

Visual Basic of Applications: Become Excel VBA Programmer

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: