Visual Basic For Excel - Microsoft VBA Excel Tutorial - Udemy

Visual Basic for Excel - Microsoft VBA Excel TutorialRating: 4.2 out of 54.2(1,705 ratings)14,011 studentsOffice ProductivityMicrosoftExcel VBAPreview this courseVisual Basic for Excel - Microsoft VBA Excel TutorialMaster Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft ExpertCreated byInfinite SkillsLast updated 1/2017EnglishEnglishPreview this course

Explore related topics

Course content

12 sections • 90 lectures • 8h 6m total lengthExpand all sections

Getting Started6 lectures • 18min

• Working Files - Download These First0:01
• What Will I Get Out Of This CoursePreview3:56
• The Excel Working Files ExplainedPreview3:00
• What Is VBA For Excel?Preview5:07
• Excel 2010 Security Settings And Macro Files3:44
• The Developer Ribbon1:54

Macros5 lectures • 19min

• Recording And Running A Simple Macro3:51
• Editing An Existing Macro In The Visual Basic Editor3:59
• The New Macro Enabled File Type2:22
• Quick Tour Of The Excel Visual Basic Editor6:00
• Watch A Macro Write Your VBA2:58

Procedures And Functions5 lectures • 15min

• What Is A Module?3:19
• Creating A Sub Procedure Manually3:14
• How To Call A Sub Procedure2:49
• Creating A Function Procedure2:51
• How To Call A Function2:57

Getting Started With VBA Programming11 lectures • 52min

• Using Comments Within Your VBA Code3:58
• Declaring Variables And Data Types5:29
• The Scope Of A Variable4:49
• The Static Declaration And Variable Expiry4:53
• Constants Instead Of Variables3:39
• An Intrinsic Constant3:07
• String And Date Types Expanded6:04
• Excel VBA Operators7:50
• Arrays5:07
• Multi-Dimensional Arrays3:32
• Dynamic Arrays3:22

Manipulating Excel Objects10 lectures • 1hr 1min

• Referencing Cells Using The Range Object5:28
• The CELLS Property2:46
• The OFFSET Property2:29
• The VALUE Of Ranges7:43
• The TEXT Object Of The RANGE3:01
• A Number Of Read Only RANGE Properties9:06
• The FONT Property And Colors8:20
• Formatting Numeric Values3:24
• Add Formulas To Cells Through VBA Code6:36
• Common METHODS Of The RANGE Object11:46

Working With Excel VBA Functions6 lectures • 23min

• What Is A Function?1:30
• Built In VBA Date Functions 2:29
• Text Manipulation With VBA Functions3:53
• Determining File Sizes Using FILELEN2:34
• Using Worksheet Excel Functions In VBA Code8:09
• User Defined Functions In Excel4:35

Controlling Program Flow And Execution8 lectures • 46min

• Using GOTO And Labels4:25
• Controlling The Program Flow With IF THEN ELSE4:23
• Multiple Criteria Plus Nested IFs5:27
• Adding ELSEIF To Speed Up Execution4:07
• SELECT CASE As An Alternative To IF4:24
• The FOR NEXT Loop9:25
• FOR NEXT With A VBA Collection6:32
• DO WHILE Loop6:56

Events7 lectures • 54min

• How To Create An Event6:57
• WorkBook Events - Open8:17
• Workbook Events - Closing And Saving7:32
• Workbook Triggers - Activate And Deactivate5:12
• Worksheet Triggers - Activate And Deactivate4:15
• Other Useful Worksheet Triggers9:44
• Using Application Events12:06

Debugging And Error Handling8 lectures • 51min

• Error Trapping the Easy Way7:38
• Make The VBA Ignore Errors 4:12
• Interact With The User When An Error Occurs4:58
• Making Use Of The ERR Object4:14
• Debugging Techniques6:11
• Using Breakpoints To Help Debug 5:45
• Setup And Use A Watch5:04
• Speeding Up The VBA Tips12:50

Interacting With Users Through Forms17 lectures • 1hr 54min

• Using MSGBOX To Interact With Users9:05
• Use INPUTBOX For Accepting Values From Users7:19
• Selecting A Range With The INPUT Box4:05
• An Introduction To UserForms4:06
• Creating A UserForm4:22
• Using Command Buttons In Excel5:17
• Adding Option Buttons In A Frame5:12
• Adding The Code That Makes The Form Work7:17
• Calling Your UserForm And Validating Content8:05
• UserForm Controls - The CheckBox8:10
• UserForm Controls - ListBox And/Or Combo Box10:10
• Images On UserForms5:24
• Labels And Text Boxes5:30
• Multiple Tabs On A UserForm8:10
• Allowing The User To Highlight A Range4:13
• Scrollbar And Spin Controls8:18
• Controlling Tab Order And Aligning Controls8:48

2 more sections

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.

Show moreShow lessReport abuse