ultite-excel-programmer-1crTQ
01 The Range ob<x>ject\\/001 Intro and Course Workbooks download.mp435.99MB
01 The Range ob<x>ject\\/002 Get the Developer Tab and Intro to Developer Tab.mp43.58MB
01 The Range ob<x>ject\\/003 Getting started with Range ob<x>ject.mp41.98MB
01 The Range ob<x>ject\\/004 Creating Your First cro From Scratch.mp44.26MB
01 The Range ob<x>ject\\/005 Adding a Secondary Comnd. . ..mp41.57MB
01 The Range ob<x>ject\\/006 Debugging in Excel VBA.mp42.50MB
01 The Range ob<x>ject\\/007 Sing a cro-Enabled Workbook .xl.mp42.38MB
01 The Range ob<x>ject\\/008 Several Ways to trigger your cro.mp42.12MB
01 The Range ob<x>ject\\/009 Affecting Multiple Cells with One Range Comnd - 2 Methods.mp43.06MB
01 The Range ob<x>ject\\/010 Adding Strings of Text to a Cell.mp42.54MB
01 The Range ob<x>ject\\/011 Using a Named Range with the Range ob<x>ject.mp42.16MB
01 The Range ob<x>ject\\attached_files\\001 Intro and Course Workbooks download\\/Excel-VBA-PC-vs-c-Help.pdf411.52KB
01 The Range ob<x>ject\\attached_files\\001 Intro and Course Workbooks download\\/Workbooks-Download.zip881.96KB
02 Range Properties\\/012 .VALUE Property.mp42.98MB
02 Range Properties\\/013 .TEXT Property.mp41.62MB
02 Range Properties\\/014 .ROW and Properties.mp42.11MB
02 Range Properties\\/015 .SELECT Property.mp41.53MB
02 Range Properties\\/016 Property.mp43.78MB
02 Range Properties\\/017 .ADDRESS Property.mp43.41MB
02 Range Properties\\/018 .FORMULA Property.mp47.36MB
02 Range Properties\\/019 .NUMBERFORT Property.mp43.64MB
02 Range Properties\\/020 FONT.BOLD UNDERLINE or ITALIC Properties.mp44.75MB
03 The Cells ob<x>ject\\/021 The Cells ob<x>ject.mp46.03MB
03 The Cells ob<x>ject\\/022 Using Column Letters instead of Numbers.mp42.17MB
03 The Cells ob<x>ject\\/023 Using Cells Positionally within a Range.mp43.78MB
03 The Cells ob<x>ject\\/024 Affecting ALL Cells in a Worksheet.mp45.53MB
03 The Cells ob<x>ject\\/025 Using Range ob<x>ject with Cells ob<x>ject.mp45.50MB
04 Variables\\/026 Intro to Variables.mp42.34MB
04 Variables\\/027 Declaring Variables - Variable Types.mp44.96MB
04 Variables\\/028 Declaring Variables - Types Demo.mp45.48MB
04 Variables\\/029 Calling a Procedure from Another.mp42.33MB
04 Variables\\/030 Public and Private Variables.mp45.00MB
04 Variables\\/031 Using Constants.mp43.35MB
04 Variables\\/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp414.56MB
04 Variables\\attached_files\\026 Intro to Variables\\/How-To-Use-Variables-In-Excel-Sub-Procedures-In-Visual-Basic-For-Applications.pdf164.99KB
05 Toolbars and Menus\\/033 File Menu walkthrough.mp44.89MB
05 Toolbars and Menus\\/034 Edit Menu walkthrough.mp410.03MB
05 Toolbars and Menus\\/035 View Menu walkthrough.mp45.70MB
05 Toolbars and Menus\\/036 View Menu2 - Watch Window Locals Window and Immediate Window.mp413.10MB
05 Toolbars and Menus\\/037 Watch Window Wonders.mp49.90MB
05 Toolbars and Menus\\/038 Insert and Fort Menus.mp41.68MB
05 Toolbars and Menus\\/039 Debug Menu Important.mp49.33MB
05 Toolbars and Menus\\/040 Run and Tools Menus.mp47.55MB
06 Super Important Tools and Excel Logic\\/041 Determining the Last Row in your Data Set.mp47.92MB
06 Super Important Tools and Excel Logic\\/042 Determining the Last Column in your Data Set.mp44.82MB
06 Super Important Tools and Excel Logic\\/043 Determining the Next Row in your Data Set.mp43.15MB
06 Super Important Tools and Excel Logic\\/044 Recording a cro.mp47.26MB
06 Super Important Tools and Excel Logic\\/045 BONUS - Dynamic Sorting.mp416.57MB
06 Super Important Tools and Excel Logic\\/046 Absolute vs Relative References.mp47.89MB
06 Super Important Tools and Excel Logic\\/047 Using With and End With.mp46.34MB
06 Super Important Tools and Excel Logic\\/048 Comparison Operators in Excel VBA.mp41.94MB
06 Super Important Tools and Excel Logic\\/049 If Then Statement.mp44.01MB
06 Super Important Tools and Excel Logic\\/050 Using Is Not Equal To.mp41.52MB
06 Super Important Tools and Excel Logic\\/051 Logical Operator NOT.mp41.86MB
06 Super Important Tools and Excel Logic\\/052 If Then Else Statement.mp42.77MB
06 Super Important Tools and Excel Logic\\/053 If Then ElseIF Statement. . ..mp43.91MB
06 Super Important Tools and Excel Logic\\/054 Comparitive Operators with Text and Numbers.mp43.95MB
06 Super Important Tools and Excel Logic\\/055 Use If Then Statements in a One-Liner of code.mp42.82MB
06 Super Important Tools and Excel Logic\\/056 Using GOTO and Labels.mp42.95MB
06 Super Important Tools and Excel Logic\\/057 Select Case as Alternative to IF THEN Statements.mp44.18MB
06 Super Important Tools and Excel Logic\\/058 Message Box with Yes and No Buttons.mp49.95MB
06 Super Important Tools and Excel Logic\\/059 Relative Positioning using Offset.mp45.50MB
06 Super Important Tools and Excel Logic\\/060 BONUS - User Defined Functions 101.mp413.50MB
06 Super Important Tools and Excel Logic\\/061 BONUS - UDF Lesson 2.mp412.78MB
06 Super Important Tools and Excel Logic\\attached_files\\048 Comparison Operators in Excel VBA\\/Comparison-Operators-In-Excel-VBA.pdf170.43KB
07 Loops and Report Writing Basics\\/062 Intro to Loops the For Next Loop.mp44.00MB
07 Loops and Report Writing Basics\\/063 Fun with our For Next Loop.mp46.85MB
07 Loops and Report Writing Basics\\/0 Beginning our first Report using Loops.mp410.91MB
07 Loops and Report Writing Basics\\/065 Using an InputBox.mp45.06MB
07 Loops and Report Writing Basics\\/066 Adding InputBox to Our First Report to ke it Dynamic.mp45.19MB
07 Loops and Report Writing Basics\\/067 Add a Button to Open Our Report.mp47.75MB
07 Loops and Report Writing Basics\\/068 Add a Cool Looking Button or Ige to Open Report.mp46.07MB
07 Loops and Report Writing Basics\\/069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp48.87MB
07 Loops and Report Writing Basics\\/070 Printable Report Part 2 - Getting Items On Report Sheet.mp411.55MB
07 Loops and Report Writing Basics\\/071 Printable Report Part 3 - Clearing Last Report.mp412.37MB
07 Loops and Report Writing Basics\\/072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp410.35MB
07 Loops and Report Writing Basics\\/073 Using PrintPreview Autotically.mp43.16MB
07 Loops and Report Writing Basics\\/074 Using PrintOut to Send Directly to Default Printer.mp45.34MB
07 Loops and Report Writing Basics\\/075 Handling Debug Error When Cancelling InputBox.mp47.10MB
07 Loops and Report Writing Basics\\/076 For Loop Going Backwards using STEP.mp47.86MB
07 Loops and Report Writing Basics\\/077 The FOR EACH Loop.mp49.50MB
07 Loops and Report Writing Basics\\/078 FOR EACH Loop - Practical Examples.mp46.41MB
07 Loops and Report Writing Basics\\/079 Intro to DO LOOPS.mp47.51MB
07 Loops and Report Writing Basics\\/080 DO Until.mp42.95MB
07 Loops and Report Writing Basics\\/081 Loop Until.mp42.28MB
07 Loops and Report Writing Basics\\/082 DO While.mp42.66MB
07 Loops and Report Writing Basics\\/083 Loop While.mp41.57MB
07 Loops and Report Writing Basics\\/084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp42.37MB
08 EVENTS Worksheet Events de Easy\\/085 Intro to Worksheet Events and Selection_Change.mp46.38MB
08 EVENTS Worksheet Events de Easy\\/086 Worksheet Activate Event.mp42.44MB
08 EVENTS Worksheet Events de Easy\\/087 Worksheet Deactivate Event.mp44.35MB
08 EVENTS Worksheet Events de Easy\\/088 BeforeDelete Event - for Worksheet Deletion.mp42.38MB
08 EVENTS Worksheet Events de Easy\\/089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp44.86MB
08 EVENTS Worksheet Events de Easy\\/090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp42.63MB
08 EVENTS Worksheet Events de Easy\\/091 Calculate Event.mp45.93MB
08 EVENTS Worksheet Events de Easy\\/092 How to Disable Events on the Workbook.mp42.81MB
08 EVENTS Worksheet Events de Easy\\/093 Intro to Change Event.mp42.14MB
08 EVENTS Worksheet Events de Easy\\/094 Change Event with EnableEvents toggle - oid endless loop.mp47.74MB
08 EVENTS Worksheet Events de Easy\\/095 Change Event Triggered with Custom Range Using Intersect.mp45.54MB
08 EVENTS Worksheet Events de Easy\\/096 FollowHyperli<x>nks Event.mp46.19MB
08 EVENTS Worksheet Events de Easy\\/097 Final Thoughts on Worksheet Events and Review Other Events.mp44.50MB
08 EVENTS Worksheet Events de Easy\\/098 Events Exercise 1.mp415.61MB
09 WorkBook Events\\/099 Workbook Open.mp48.85MB
09 WorkBook Events\\/100 Workbook Activate.mp44.64MB
09 WorkBook Events\\/101 Before Se.mp45.12MB
09 WorkBook Events\\/102 After Se.mp47.45MB
09 WorkBook Events\\/103 Before Close.mp49.81MB
09 WorkBook Events\\/104 Before Print.mp43.53MB
09 WorkBook Events\\/105 Deactivate.mp43.37MB
09 WorkBook Events\\/106 NewChart.mp49.22MB
09 WorkBook Events\\/107 NewSheet.mp44.26MB
09 WorkBook Events\\/108 Sheet Activate.mp46.83MB
09 WorkBook Events\\/109 Delete DoubleClick RightClick Calculate Change.mp412.39MB
09 WorkBook Events\\/110 SheetDeactivate.mp47.02MB
09 WorkBook Events\\/111 Follow Hyperli<x>nk.mp43.49MB
09 WorkBook Events\\/112 SheetSelection<x>change.mp44.36MB
09 WorkBook Events\\/113 WindowActivate.mp43.38MB
09 WorkBook Events\\/ WindowDeactivate.mp42.36MB
09 WorkBook Events\\/115 WindowResize.mp47.28MB
10 Activex Controls on Worksheets\\/116 Activex Controls vs Forms Controls.mp45.84MB
10 Activex Controls on Worksheets\\/117 Button Click - Wage Calculator.mp46.59MB
10 Activex Controls on Worksheets\\/118 Keydown Event.mp46.09MB
10 Activex Controls on Worksheets\\/119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp46.77MB
10 Activex Controls on Worksheets\\/120 KeyPress Event.mp46.67MB
10 Activex Controls on Worksheets\\/121 MouseMove Event.mp43.39MB
10 Activex Controls on Worksheets\\/122 MouseMove Event with Application.Statuar - fun and useful.mp46.41MB
10 Activex Controls on Worksheets\\/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp411.41MB
10 Activex Controls on Worksheets\\/124 GotFocus and LostFocus Events.mp42.27MB
10 Activex Controls on Worksheets\\/125 Use a Checkbox for its VALUE.mp44.54MB
10 Activex Controls on Worksheets\\/126 Checkbox Event Without a Button.mp42.84MB
10 Activex Controls on Worksheets\\/127 li<x>nkedCell Property with a Checkbox.mp42.28MB
10 Activex Controls on Worksheets\\/128 Option Buttons Intro - What is an Option Button and Grouping.mp44.53MB
10 Activex Controls on Worksheets\\/129 Grouping Alignment and Aesthetics for Controls.mp44.52MB
10 Activex Controls on Worksheets\\/130 Homede Quiz using Option Buttons and a Command Button.mp47.01MB
10 Activex Controls on Worksheets\\/131 Compliance Checker for your Forms or Quizzes Part 1.mp46.54MB
10 Activex Controls on Worksheets\\/132 Compliance check part 2.mp420.01MB
10 Activex Controls on Worksheets\\/133 SpinButton with Cell A1.mp46.66MB
10 Activex Controls on Worksheets\\/134 SpinButtons with Textboxes and Numbers.mp49.94MB
10 Activex Controls on Worksheets\\/135 SpinButton BONUS - Move Textbox Position with SpinButton.mp48.74MB
10 Activex Controls on Worksheets\\/136 SpinButton with Dates in a Textbox.mp46.85MB
10 Activex Controls on Worksheets\\/137 Activex Label Control - Basics.mp46.79MB
10 Activex Controls on Worksheets\\/138 ComboBox - Fill with ListFillRange.mp47.73MB
10 Activex Controls on Worksheets\\/139 Creating a Dynamic Range.mp48.63MB
10 Activex Controls on Worksheets\\/140 ComboBox - How to use Multiple Columns.mp46.25MB
10 Activex Controls on Worksheets\\/141 Using .ADDITEM to Get Specific items in your Combobox List.mp417.73MB
10 Activex Controls on Worksheets\\/142 Noteworthy Properties of a Combobox.mp412.00MB
10 Activex Controls on Worksheets\\/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp416.21MB
10 Activex Controls on Worksheets\\/144 ListBox Basics using Dynamic Range.mp415.37MB
10 Activex Controls on Worksheets\\/145 Listbox Click event and Dynamic Options.mp47.11MB
10 Activex Controls on Worksheets\\/146 BONUS - nipulating and Using Multiselect Items in a Listbox.mp410.54MB
10 Activex Controls on Worksheets\\/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp410.61MB
10 Activex Controls on Worksheets\\/148 Dynamic ListBoxes Using .ADDITEM and More.mp419.80MB
10 Activex Controls on Worksheets\\/149 ke and Utilize INVISIBLE Columns - Special Trick.mp46.47MB
10 Activex Controls on Worksheets\\/150 Using a Scroll Bar on a worksheet.mp44.72MB
10 Activex Controls on Worksheets\\/151 Pictures on a Worksheet plus using FollowHyperli<x>nk Method.mp413.91MB
10 Activex Controls on Worksheets\\/152 Toggle Button.mp44.57MB
10 Activex Controls on Worksheets\\/153 A Brief Note on Alternate 3rd Party Controls.mp42.90MB
10 Activex Controls on Worksheets\\attached_files\\118 Keydown Event\\/Key-Code-Constants-Used-With-Key-Down-Events.pdf108.94KB
10 Activex Controls on Worksheets\\attached_files\\123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl\\/Mouse-Down-Event-Excel-VBA-Language-Reference-.pdf148.46KB
10 Activex Controls on Worksheets\\attached_files\\143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc\\/List-Box-Combobox-LIST-Principles.pdf137.94KB
11 Userforms - the best thing. EVER\\/154 Userform - Hide Show and Unload.mp49.13MB
11 Userforms - the best thing. EVER\\/155 Sample Databa<x>se and Creating a Data Entry Form.mp434.48MB
11 Userforms - the best thing. EVER\\/156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp49.39MB
11 Userforms - the best thing. EVER\\/157 New Employee Data Entry Form.mp436.52MB
11 Userforms - the best thing. EVER\\/158 Fort Textbox Numbers as Numerals Clearing out Form upon Submission.mp48.69MB
11 Userforms - the best thing. EVER\\/159 Set the Tab Order for Userform Controls.mp45.51MB
11 Userforms - the best thing. EVER\\/160 Set Default Values to ke Data Entry Easier.mp45.47MB
11 Userforms - the best thing. EVER\\/161 oid Duplicate Employee ID and other Fun Autotion Tricks.mp415.76MB
11 Userforms - the best thing. EVER\\/162 Edit Mode for Employee Databa<x>se - Part 1.mp437.32MB
11 Userforms - the best thing. EVER\\/163 Edit Mode for Employee Databa<x>se - Part 2.mp425.05MB
11 Userforms - the best thing. EVER\\/1 Edit Mode Pt 3 - Adding Autotion and Se Button.mp443.94MB
11 Userforms - the best thing. EVER\\/165 Userform Report with Filters - Part 1.mp426.37MB
11 Userforms - the best thing. EVER\\/166 Userform Report with Filters - Part 2.mp415.71MB
11 Userforms - the best thing. EVER\\/167 Applying the Dynamic Filters to Reports.mp48.46MB
11 Userforms - the best thing. EVER\\/168 Clear out Last Report.mp46.99MB
11 Userforms - the best thing. EVER\\/169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp410.65MB
11 Userforms - the best thing. EVER\\/170 Concluding Thoughts. . ..mp43.36MB
12 BONUS Section - VBA Functions\\/171 InStr Function - Search for Text Within Other Text.mp414.78MB
12 BONUS Section - VBA Functions\\/172 The EVALUATE Function - c-Daddy of all functions.mp413.47MB
12 BONUS Section - VBA Functions\\/173 Sum Function in Excel VBA - EASY.mp47.74MB
12 BONUS Section - VBA Functions\\/174 Count Function in VBA.mp44.75MB
- CreateTime2021-10-15
- UpdateTime2021-10-21
- FileTotalCount199
- TotalSize2.58GBHotTimes5ViewTimes10DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.SAMA-336 2.FETI-008 3.GYAZ-104 4.ALD-649 5.VSPDS-634 6.TLSO-004 7.NATR-218 8.OKAD-459 9.DFDA-090 10.EMRD-032 11.YTR-012 12.AOZ-036 13.TMGK-073 14.HPK-005 15.MBYD-140 16.DAID-016 17.TEN-14 18.CADV-419 19.SCPR-004 20.DSE-830 21.COSQ-012 22.BOIN-048 23.PSSD-113 24.JFB-021 25.TYWD-017 26.MKCK-018 27.ONSD-610 28.IDBD-188 29.MIBD-667 30.RKI-185 31.JMD-03 32.DVDPS-622 33.DVUMA-039 34.MIBD-057 35.PDA-003 36.MIBD-447 37.VVVD-084 38.YAB-036 39.ONSD-348 40.KNCS-068 41.AST-30 42.SPRD-146 43.SNYD-009 44.MXSPS-220 45.RGD-127 46.DKSW-219 47.SWF-194 48.PGD-624 49.DVDPS-319 50.ADV-0155 51.INU-044 52.NFDM-170 53.DJNO-028 54.LAN-002 55.AA-761 56.EMBF-009 57.NHDTA-191 58.UYXX-001 59.AEIL-013 60.TEND-002 61.WCD-044 62.LHBS-001 63.OKAS-066 64.GFT-196 65.MASD-024 66.ONSD-163 67.RAN-116T 68.DINM-094 69.AA-797 70.IMG-277 71.336 72.008 73.104 74.9 75.634 76.004 77.218 78.459 79.090 80.032 81.012 82.036 83.073 84.005 85.140 86.016 87.14 88.419 89.004 90.830 91.012 92.048 93.113 94.021 95.017 96.018 97.610 98.188 99.667 100.185 101.03 102.622 103.039 104.057 105.003 106.447 107.084 108.036 109.348 110.068 111.30 112.146 113.009 114.220 115.127 116.219 117.194 118.624 119.319 120.0155 121.044 122.170 123.028 124.002 125.761 126.009 127.191 128.001 129.013 130.002 131.044 132.001 133.066 134.196 135.024 136.163 137.116T 138.094 139.797 140.277