~Get Your Files Here !

  01 Getting started with macros. Recording, editing and saving macros

   001 Introduction.mp4

   002 Enabling VBA Developer tab in the Ribbon.mp4

   003 Recording a macro.en.srt

   004 View and analyze recorded macro code.en.srt

   005 Edit a recorded macro code.mp4

   006 Record macros using Absolute and Relative modes and compare results.en.srt

   006 RelativeReferencingExercise.xlsm

   007 Saving your macro-enabled workbook.mp4

   008 Exercise2.docx

   008 Trusting workbook to avoid security issues.en.srt

   008 invoice.txt

  02 Getting started with writing VBA Code and explore the VBE interface

   001 Explore the Visual Basic for Application coding Editor interface.mp4

   002 Creating your first VBA code.mp4

   004 Adding Form Controls.en.srt

   005 Understanding Excel's object hierarchy.mp4

   006 Identify worksheet ranges.mp4

   009 L1_ExploringEditor.mp4

  03 Summary of last section and fundamentals of variables and data types

   001 Creating variables.mp4

   002 Defining data types.mp4

   003 Managing strings.mp4

  04 VBA programming with Arrays

   002 Array versus regular variables compared.en.srt

   003 A closer look of static and dynamic arrays.en.srt

   004 Looping within arrays.en.srt

   005 Using the Erase() function.en.srt

   006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.en.srt

   024 REDIM PRESERVE EXERCISE.docx

  05 Creating function procedures

   001 Creating function procedures.mp4

   002 Testing custom functions.mp4

   003 Function procedures, function scope and setting reference from other workbooks.mp4

   005 Calling function in worksheet formulas.en.srt

   006 Demonstrate using custom function in conditional formatting rule.en.srt

   007 A closer look at function arguments.mp4

   008 Example of a single argument function.mp4

   009 Example of a two argument function.mp4

   010 Functions that accept optional arguments.mp4

   011 Arrays revisited_ Functions that return arrays.mp4

   012 Functions that accept infinite number of arguments.mp4

   013 We learn how to provide descriptions of our function and its arguments.mp4

   037 FunctionProcedureExercise.docx

  06 Working with VBA Events

   002 Overview of VBA events_ Understanding event sequence.mp4

   004 Event handler procedures that use arguments.mp4

   005 Workbook-level events.mp4

   006 Workbook-level events example coding.mp4

   008 Workbook_Activate example.mp4

   010 A look at the BeforeSave Event handler.en.srt

   011 The Deactivate event.mp4

   012 The BeforePrint event procedure.mp4

   014 The BeforeRightClick event.mp4

   051 SelectionChangeExercise.docm

  07 VBA error handling techniques

   001 Section introduction.mp4

   002 Types of VBA errors.mp4

   003 Trapping errors.mp4

   004 Using the Err object_ An example.mp4

   005 Examples of VBA error handling techniques.mp4

  08 VBA Hands-on examples

   001 Introduction to lecture and review of previous lecture.mp4

   002 Working with worksheet ranges_ Copying ranges.mp4

   004 Copy a variable size range_ The CurrentRange method of the Range object.mp4

   005 Tips for working with ranges.mp4

   006 How to identify various types of ranges such as the first empty cell in a column.mp4

   007 Range selection examples.mp4

   009 Prompting for user input.en.srt

   010 A mode advanced use of the InputBox function.en.srt

   011 More discussion on the InputBox function, populating cells with InputBox values.en.srt

   012 Pausing macro for range selection.en.srt

   013 Counting selected cells.en.srt

   014 Determining types of selected range_ single cell, contiguous range of cells etc.en.srt

   015 Code to check for existence of a worksheet in a workbook.en.srt

   016 Accessing the parents of an Excel object.mp4

   017 Opening files to extract data for worksheets using Application.GetOpenFilename().mp4

   018 Saving a file.mp4

   063 range selections.xlsm

  09 Using UserForms and Controls to provide interactivity

   001 Introduction_ What we are going to learn in this section.mp4

   002 Inserting UserForms in VBA projects.mp4

   003 We learn of the different control types on the Toolbox.mp4

   004 Using the Properties Window to adjust properties of controls.mp4

   005 Naming controls.mp4

   006 Displaying forms.mp4

  10 Developing a VBA Application

   001 Introduction to section.mp4

   002 A practical demonstration of UserForm modal and non-modal modes.mp4

   003 Progress bar demo application.mp4

   004 Using the Multipage control to develop a Books application.mp4