|
|
001 Creating function procedures.en.srt
|
SRT
|
16 KB
|
|
|
001 Creating function procedures.mp4
|
MP4
|
195.7 MB
|
|
|
001 Creating variables.en.srt
|
SRT
|
8.1 KB
|
|
|
001 Creating variables.mp4
|
MP4
|
85.6 MB
|
|
|
001 Explore the Visual Basic for Application coding Editor interface.en.srt
|
SRT
|
3.2 KB
|
|
|
001 Explore the Visual Basic for Application coding Editor interface.mp4
|
MP4
|
41.4 MB
|
|
|
001 Introduction to lecture and review of previous lecture.en.srt
|
SRT
|
2.1 KB
|
|
|
001 Introduction to lecture and review of previous lecture.mp4
|
MP4
|
19.7 MB
|
|
|
001 Introduction to section.en.srt
|
SRT
|
1 KB
|
|
|
001 Introduction to section.mp4
|
MP4
|
4.9 MB
|
|
|
001 Introduction.en.srt
|
SRT
|
2.6 KB
|
|
|
001 Introduction.mp4
|
MP4
|
17.7 MB
|
|
|
001 Introduction_ What we are going to learn in this section.en.srt
|
SRT
|
1.5 KB
|
|
|
001 Introduction_ What we are going to learn in this section.mp4
|
MP4
|
3.6 MB
|
|
|
001 Section introduction.en.srt
|
SRT
|
2 KB
|
|
|
001 Section introduction.mp4
|
MP4
|
11.9 MB
|
|
|
001 The anatomy of arrays.mp4
|
MP4
|
49.8 MB
|
|
|
001 Understanding the sequence of events.mp4
|
MP4
|
12.4 MB
|
|
|
002 A practical demonstration of UserForm modal and non-modal modes.en.srt
|
SRT
|
9.5 KB
|
|
|
002 A practical demonstration of UserForm modal and non-modal modes.mp4
|
MP4
|
46.8 MB
|
|
|
002 Array versus regular variables compared.en.srt
|
SRT
|
3.6 KB
|
|
|
002 Array versus regular variables compared.mp4
|
MP4
|
18 MB
|
|
|
002 Creating your first VBA code.en.srt
|
SRT
|
4.3 KB
|
|
|
002 Creating your first VBA code.mp4
|
MP4
|
19.5 MB
|
|
|
002 Defining data types.en.srt
|
SRT
|
12.9 KB
|
|
|
002 Defining data types.mp4
|
MP4
|
40.6 MB
|
|
|
002 Enabling VBA Developer tab in the Ribbon.en.srt
|
SRT
|
1.6 KB
|
|
|
002 Enabling VBA Developer tab in the Ribbon.mp4
|
MP4
|
8.3 MB
|
|
|
002 Inserting UserForms in VBA projects.en.srt
|
SRT
|
4.1 KB
|
|
|
002 Inserting UserForms in VBA projects.mp4
|
MP4
|
19.5 MB
|
|
|
002 Overview of VBA events_ Understanding event sequence.mp4
|
MP4
|
52.5 MB
|
|
|
002 Testing custom functions.en.srt
|
SRT
|
6.5 KB
|
|
|
002 Testing custom functions.mp4
|
MP4
|
30.2 MB
|
|
|
002 Types of VBA errors.en.srt
|
SRT
|
819.2 B
|
|
|
002 Types of VBA errors.mp4
|
MP4
|
3.7 MB
|
|
|
002 Working with worksheet ranges_ Copying ranges.en.srt
|
SRT
|
5.8 KB
|
|
|
002 Working with worksheet ranges_ Copying ranges.mp4
|
MP4
|
19.3 MB
|
|
|
003 A closer look of static and dynamic arrays.en.srt
|
SRT
|
17 KB
|
|
|
003 A closer look of static and dynamic arrays.mp4
|
MP4
|
67.2 MB
|
|
|
003 Adding toolbar buttons.mp4
|
MP4
|
22.6 MB
|
|
|
003 Calling standard modules from event handler procedures.mp4
|
MP4
|
25 MB
|
|
|
003 Function procedures, function scope and setting reference from other workbooks.en.srt
|
SRT
|
23.2 KB
|
|
|
003 Function procedures, function scope and setting reference from other workbooks.mp4
|
MP4
|
92.4 MB
|
|
|
003 L1_Macro_Exercise.xlsm
|
XLSM
|
10.8 KB
|
|
|
003 Managing strings.en.srt
|
SRT
|
21.8 KB
|
|
|
003 Managing strings.mp4
|
MP4
|
90 MB
|
|
|
003 More discussion on copying ranges.mp4
|
MP4
|
50.3 MB
|
|
|
003 Progress bar demo application.en.srt
|
SRT
|
10.8 KB
|
|
|
003 Progress bar demo application.mp4
|
MP4
|
48.3 MB
|
|
|
003 Recording a macro.en.srt
|
SRT
|
4 KB
|
|
|
003 Recording a macro.mp4
|
MP4
|
18 MB
|
|
|
003 Trapping errors.en.srt
|
SRT
|
6.7 KB
|
|
|
003 Trapping errors.mp4
|
MP4
|
28.8 MB
|
|
|
003 We learn of the different control types on the Toolbox.en.srt
|
SRT
|
6.8 KB
|
|
|
003 We learn of the different control types on the Toolbox.mp4
|
MP4
|
38.4 MB
|
|
|
004 Adding Form Controls.en.srt
|
SRT
|
5.1 KB
|
|
|
004 Adding Form Controls.mp4
|
MP4
|
19.4 MB
|
|
|
004 Copy a variable size range_ The CurrentRange method of the Range object.mp4
|
MP4
|
57.2 MB
|
|
|
004 Event handler procedures that use arguments.mp4
|
MP4
|
50.7 MB
|
|
|
004 Executing function procedures.mp4
|
MP4
|
101.9 MB
|
|
|
004 Looping within arrays.en.srt
|
SRT
|
6.6 KB
|
|
|
004 Looping within arrays.mp4
|
MP4
|
24 MB
|
|
|
004 Using the Err object_ An example.en.srt
|
SRT
|
6.1 KB
|
|
|
004 Using the Err object_ An example.mp4
|
MP4
|
29.5 MB
|
|
|
004 Using the Multipage control to develop a Books application.en.srt
|
SRT
|
29.1 KB
|
|
|
004 Using the Multipage control to develop a Books application.mp4
|
MP4
|
182.8 MB
|
|
|
004 Using the Properties Window to adjust properties of controls.en.srt
|
SRT
|
8.2 KB
|
|
|
004 Using the Properties Window to adjust properties of controls.mp4
|
MP4
|
37.6 MB
|
|
|
004 View and analyze recorded macro code.en.srt
|
SRT
|
7.4 KB
|
|
|
004 View and analyze recorded macro code.mp4
|
MP4
|
33.1 MB
|
|
|
005 Calling function in worksheet formulas.en.srt
|
SRT
|
10.5 KB
|
|
|
005 Calling function in worksheet formulas.mp4
|
MP4
|
56.2 MB
|
|
|
005 Edit a recorded macro code.mp4
|
MP4
|
70.2 MB
|
|
|
005 EditingMacroExercise.xlsm
|
XLSM
|
14.2 KB
|
|
|
005 Examples of VBA error handling techniques.en.srt
|
SRT
|
10.3 KB
|
|
|
005 Examples of VBA error handling techniques.mp4
|
MP4
|
53.6 MB
|
|
|
005 Naming controls.en.srt
|
SRT
|
3.1 KB
|
|
|
005 Naming controls.mp4
|
MP4
|
16.6 MB
|
|
|
005 Tips for working with ranges.en.srt
|
SRT
|
7.8 KB
|
|
|
005 Tips for working with ranges.mp4
|
MP4
|
34.6 MB
|
|
|
005 Understanding Excel's object hierarchy.mp4
|
MP4
|
52 MB
|
|
|
005 Using the Erase() function.en.srt
|
SRT
|
2.3 KB
|
|
|
005 Using the Erase() function.mp4
|
MP4
|
9.4 MB
|
|
|
005 Workbook-level events.en.srt
|
SRT
|
2.8 KB
|
|
|
005 Workbook-level events.mp4
|
MP4
|
15 MB
|
|
|
006 Demonstrate using custom function in conditional formatting rule.en.srt
|
SRT
|
10.5 KB
|
|
|
006 Demonstrate using custom function in conditional formatting rule.mp4
|
MP4
|
56.2 MB
|
|
|
006 Displaying forms.en.srt
|
SRT
|
5.1 KB
|
|
|
006 Displaying forms.mp4
|
MP4
|
28.1 MB
|
|
|
006 How to identify various types of ranges such as the first empty cell in a column.en.srt
|
SRT
|
4 KB
|
|
|
006 How to identify various types of ranges such as the first empty cell in a column.mp4
|
MP4
|
29.4 MB
|
|
|
006 Identify worksheet ranges.en.srt
|
SRT
|
18.2 KB
|
|
|
006 Identify worksheet ranges.mp4
|
MP4
|
83 MB
|
|
|
006 Record macros using Absolute and Relative modes and compare results.en.srt
|
SRT
|
8.3 KB
|
|
|
006 Record macros using Absolute and Relative modes and compare results.mp4
|
MP4
|
52.5 MB
|
|
|
006 RelativeReferencingExercise.xlsm
|
XLSM
|
14.3 KB
|
|
|
006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.en.srt
|
SRT
|
13.6 KB
|
|
|
006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.mp4
|
MP4
|
51.3 MB
|
|
|
006 Workbook-level events example coding.en.srt
|
SRT
|
5.3 KB
|
|
|
006 Workbook-level events example coding.mp4
|
MP4
|
28.7 MB
|
|
|
007 A closer look at function arguments.mp4
|
MP4
|
27.9 MB
|
|
|
007 How to properly addressing cells and ranges on a worksheet.mp4
|
MP4
|
102.6 MB
|
|
|
007 Managing lists using the ListBox and the ComboBox controls.mp4
|
MP4
|
67.9 MB
|
|
|
007 Range selection examples.en.srt
|
SRT
|
2.6 KB
|
|
|
007 Range selection examples.mp4
|
MP4
|
12.8 MB
|
|
|
007 Saving your macro-enabled workbook.en.srt
|
SRT
|
4.8 KB
|
|
|
007 Saving your macro-enabled workbook.mp4
|
MP4
|
32.7 MB
|
|
|
007 Worksheet-level events example.mp4
|
MP4
|
25.3 MB
|
|
|
008 EXERCISES1.docx
|
DOCX
|
14.6 KB
|
|
|
008 Example of a single argument function.en.srt
|
SRT
|
3.4 KB
|
|
|
008 Example of a single argument function.mp4
|
MP4
|
16.9 MB
|
|
|
008 Exercise2.docx
|
DOCX
|
120.1 KB
|
|
|
008 Exercise3.docx
|
DOCX
|
13.9 KB
|
|
|
008 Trusting workbook to avoid security issues.en.srt
|
SRT
|
4.6 KB
|
|
|
008 Trusting workbook to avoid security issues.mp4
|
MP4
|
38.8 MB
|
|
|
008 Using the Resize property of the Range object to handle varying size ranges.mp4
|
MP4
|
79.8 MB
|
|
|
008 Workbook_Activate example.mp4
|
MP4
|
24.9 MB
|
|
|
008 invoice.txt
|
TXT
|
512 B
|
|
|
008 invoice1.txt
|
TXT
|
1 KB
|
|
|
009 Example of a two argument function.en.srt
|
SRT
|
3.4 KB
|
|
|
009 Example of a two argument function.mp4
|
MP4
|
16.9 MB
|
|
|
009 L1_ExploringEditor.mp4
|
MP4
|
20 MB
|
|
|
009 Prompting for user input.en.srt
|
SRT
|
8 KB
|
|
|
009 Prompting for user input.mp4
|
MP4
|
29.7 MB
|
|
|
009 The NewSheet Event procedure.mp4
|
MP4
|
13.6 MB
|
|
|
010 A look at the BeforeSave Event handler.en.srt
|
SRT
|
4.1 KB
|
|
|
010 A look at the BeforeSave Event handler.mp4
|
MP4
|
20.1 MB
|
|
|
010 A mode advanced use of the InputBox function.en.srt
|
SRT
|
9.5 KB
|
|
|
010 A mode advanced use of the InputBox function.mp4
|
MP4
|
38.8 MB
|
|
|
010 Functions that accept optional arguments.en.srt
|
SRT
|
8.6 KB
|
|
|
010 Functions that accept optional arguments.mp4
|
MP4
|
36 MB
|
|
|
011 Arrays revisited_ Functions that return arrays.en.srt
|
SRT
|
4.9 KB
|
|
|
011 Arrays revisited_ Functions that return arrays.mp4
|
MP4
|
20.1 MB
|
|
|
011 More discussion on the InputBox function, populating cells with InputBox values.en.srt
|
SRT
|
8.8 KB
|
|
|
011 More discussion on the InputBox function, populating cells with InputBox values.mp4
|
MP4
|
39.4 MB
|
|
|
011 The Deactivate event.mp4
|
MP4
|
18.1 MB
|
|
|
012 Functions that accept infinite number of arguments.en.srt
|
SRT
|
5.5 KB
|
|
|
012 Functions that accept infinite number of arguments.mp4
|
MP4
|
19.9 MB
|
|
|
012 Pausing macro for range selection.en.srt
|
SRT
|
5.2 KB
|
|
|
012 Pausing macro for range selection.mp4
|
MP4
|
26 MB
|
|
|
012 The BeforePrint event procedure.en.srt
|
SRT
|
3.4 KB
|
|
|
012 The BeforePrint event procedure.mp4
|
MP4
|
18 MB
|
|
|
013 Counting selected cells.en.srt
|
SRT
|
7 KB
|
|
|
013 Counting selected cells.mp4
|
MP4
|
47.5 MB
|
|
|
013 The WorksheetChange event.mp4
|
MP4
|
33.7 MB
|
|
|
013 We learn how to provide descriptions of our function and its arguments.en.srt
|
SRT
|
8.6 KB
|
|
|
013 We learn how to provide descriptions of our function and its arguments.mp4
|
MP4
|
58.5 MB
|
|
|
014 Determining types of selected range_ single cell, contiguous range of cells etc.en.srt
|
SRT
|
4.9 KB
|
|
|
014 Determining types of selected range_ single cell, contiguous range of cells etc.mp4
|
MP4
|
15.6 MB
|
|
|
014 The BeforeRightClick event.mp4
|
MP4
|
38.8 MB
|
|
|
015 Code to check for existence of a worksheet in a workbook.en.srt
|
SRT
|
1.2 KB
|
|
|
015 Code to check for existence of a worksheet in a workbook.mp4
|
MP4
|
6 MB
|
|
|
015 WritingMacros.docx
|
DOCX
|
17.2 KB
|
|
|
016 Accessing the parents of an Excel object.mp4
|
MP4
|
23.2 MB
|
|
|
017 Opening files to extract data for worksheets using Application.GetOpenFilename().en.srt
|
SRT
|
9.5 KB
|
|
|
017 Opening files to extract data for worksheets using Application.GetOpenFilename().mp4
|
MP4
|
43.9 MB
|
|
|
018 ManagingStrings.docx
|
DOCX
|
13.8 KB
|
|
|
018 Saving a file.en.srt
|
SRT
|
921.6 B
|
|
|
018 Saving a file.mp4
|
MP4
|
6 MB
|
|
|
019 Creating Data Forms based on data in a worksheet.mp4
|
MP4
|
45.5 MB
|
|
|
024 REDIM PRESERVE EXERCISE.docx
|
DOCX
|
43.5 KB
|
|
|
037 ArrayExercises.docm
|
DOCM
|
350.8 KB
|
|
|
037 FunctionProcedureExercise.docx
|
DOCX
|
16.7 KB
|
|
|
051 Event handler exercises.docm
|
DOCM
|
87.1 KB
|
|
|
051 SelectionChangeExercise.docm
|
DOCM
|
227.9 KB
|
|
|
051 ValidateCode.docm
|
DOCM
|
88.3 KB
|
|
|
063 range selections.xlsm
|
XLSM
|
71.9 KB
|
|
|
086 Sub Procedure And Array Exercise.docx
|
DOCX
|
279.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
![[ FreeCourseWeb ] Professional Excel VBA - Udemy](/static/img/no-torrent-image.png "[ FreeCourseWeb ] Professional Excel VBA - Udemy")
