fileultite-excel-programmer-1crTQ

ultite excel programmer
  • MP401 The Range ob<x>ject\\/001 Intro and Course Workbooks download.mp435.99MB
  • MP401 The Range ob<x>ject\\/002 Get the Developer Tab and Intro to Developer Tab.mp43.58MB
  • MP401 The Range ob<x>ject\\/003 Getting started with Range ob<x>ject.mp41.98MB
  • MP401 The Range ob<x>ject\\/004 Creating Your First cro From Scratch.mp44.26MB
  • MP401 The Range ob<x>ject\\/005 Adding a Secondary Comnd. . ..mp41.57MB
  • MP401 The Range ob<x>ject\\/006 Debugging in Excel VBA.mp42.50MB
  • MP401 The Range ob<x>ject\\/007 Sing a cro-Enabled Workbook .xl.mp42.38MB
  • MP401 The Range ob<x>ject\\/008 Several Ways to trigger your cro.mp42.12MB
  • MP401 The Range ob<x>ject\\/009 Affecting Multiple Cells with One Range Comnd - 2 Methods.mp43.06MB
  • MP401 The Range ob<x>ject\\/010 Adding Strings of Text to a Cell.mp42.54MB
  • MP401 The Range ob<x>ject\\/011 Using a Named Range with the Range ob<x>ject.mp42.16MB
  • PDF01 The Range ob<x>ject\\attached_files\\001 Intro and Course Workbooks download\\/Excel-VBA-PC-vs-c-Help.pdf411.52KB
  • ZIP01 The Range ob<x>ject\\attached_files\\001 Intro and Course Workbooks download\\/Workbooks-Download.zip881.96KB
  • MP402 Range Properties\\/012 .VALUE Property.mp42.98MB
  • MP402 Range Properties\\/013 .TEXT Property.mp41.62MB
  • MP402 Range Properties\\/014 .ROW and Properties.mp42.11MB
  • MP402 Range Properties\\/015 .SELECT Property.mp41.53MB
  • MP402 Range Properties\\/016 Property.mp43.78MB
  • MP402 Range Properties\\/017 .ADDRESS Property.mp43.41MB
  • MP402 Range Properties\\/018 .FORMULA Property.mp47.36MB
  • MP402 Range Properties\\/019 .NUMBERFORT Property.mp43.64MB
  • MP402 Range Properties\\/020 FONT.BOLD UNDERLINE or ITALIC Properties.mp44.75MB
  • MP403 The Cells ob<x>ject\\/021 The Cells ob<x>ject.mp46.03MB
  • MP403 The Cells ob<x>ject\\/022 Using Column Letters instead of Numbers.mp42.17MB
  • MP403 The Cells ob<x>ject\\/023 Using Cells Positionally within a Range.mp43.78MB
  • MP403 The Cells ob<x>ject\\/024 Affecting ALL Cells in a Worksheet.mp45.53MB
  • MP403 The Cells ob<x>ject\\/025 Using Range ob<x>ject with Cells ob<x>ject.mp45.50MB
  • MP404 Variables\\/026 Intro to Variables.mp42.34MB
  • MP404 Variables\\/027 Declaring Variables - Variable Types.mp44.96MB
  • MP404 Variables\\/028 Declaring Variables - Types Demo.mp45.48MB
  • MP404 Variables\\/029 Calling a Procedure from Another.mp42.33MB
  • MP404 Variables\\/030 Public and Private Variables.mp45.00MB
  • MP404 Variables\\/031 Using Constants.mp43.35MB
  • MP404 Variables\\/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp414.56MB
  • PDF04 Variables\\attached_files\\026 Intro to Variables\\/How-To-Use-Variables-In-Excel-Sub-Procedures-In-Visual-Basic-For-Applications.pdf164.99KB
  • MP405 Toolbars and Menus\\/033 File Menu walkthrough.mp44.89MB
  • MP405 Toolbars and Menus\\/034 Edit Menu walkthrough.mp410.03MB
  • MP405 Toolbars and Menus\\/035 View Menu walkthrough.mp45.70MB
  • MP405 Toolbars and Menus\\/036 View Menu2 - Watch Window Locals Window and Immediate Window.mp413.10MB
  • MP405 Toolbars and Menus\\/037 Watch Window Wonders.mp49.90MB
  • MP405 Toolbars and Menus\\/038 Insert and Fort Menus.mp41.68MB
  • MP405 Toolbars and Menus\\/039 Debug Menu Important.mp49.33MB
  • MP405 Toolbars and Menus\\/040 Run and Tools Menus.mp47.55MB
  • MP406 Super Important Tools and Excel Logic\\/041 Determining the Last Row in your Data Set.mp47.92MB
  • MP406 Super Important Tools and Excel Logic\\/042 Determining the Last Column in your Data Set.mp44.82MB
  • MP406 Super Important Tools and Excel Logic\\/043 Determining the Next Row in your Data Set.mp43.15MB
  • MP406 Super Important Tools and Excel Logic\\/044 Recording a cro.mp47.26MB
  • MP406 Super Important Tools and Excel Logic\\/045 BONUS - Dynamic Sorting.mp416.57MB
  • MP406 Super Important Tools and Excel Logic\\/046 Absolute vs Relative References.mp47.89MB
  • MP406 Super Important Tools and Excel Logic\\/047 Using With and End With.mp46.34MB
  • MP406 Super Important Tools and Excel Logic\\/048 Comparison Operators in Excel VBA.mp41.94MB
  • MP406 Super Important Tools and Excel Logic\\/049 If Then Statement.mp44.01MB
  • MP406 Super Important Tools and Excel Logic\\/050 Using Is Not Equal To.mp41.52MB
  • MP406 Super Important Tools and Excel Logic\\/051 Logical Operator NOT.mp41.86MB
  • MP406 Super Important Tools and Excel Logic\\/052 If Then Else Statement.mp42.77MB
  • MP406 Super Important Tools and Excel Logic\\/053 If Then ElseIF Statement. . ..mp43.91MB
  • MP406 Super Important Tools and Excel Logic\\/054 Comparitive Operators with Text and Numbers.mp43.95MB
  • MP406 Super Important Tools and Excel Logic\\/055 Use If Then Statements in a One-Liner of code.mp42.82MB
  • MP406 Super Important Tools and Excel Logic\\/056 Using GOTO and Labels.mp42.95MB
  • MP406 Super Important Tools and Excel Logic\\/057 Select Case as Alternative to IF THEN Statements.mp44.18MB
  • MP406 Super Important Tools and Excel Logic\\/058 Message Box with Yes and No Buttons.mp49.95MB
  • MP406 Super Important Tools and Excel Logic\\/059 Relative Positioning using Offset.mp45.50MB
  • MP406 Super Important Tools and Excel Logic\\/060 BONUS - User Defined Functions 101.mp413.50MB
  • MP406 Super Important Tools and Excel Logic\\/061 BONUS - UDF Lesson 2.mp412.78MB
  • PDF06 Super Important Tools and Excel Logic\\attached_files\\048 Comparison Operators in Excel VBA\\/Comparison-Operators-In-Excel-VBA.pdf170.43KB
  • MP407 Loops and Report Writing Basics\\/062 Intro to Loops the For Next Loop.mp44.00MB
  • MP407 Loops and Report Writing Basics\\/063 Fun with our For Next Loop.mp46.85MB
  • MP407 Loops and Report Writing Basics\\/0 Beginning our first Report using Loops.mp410.91MB
  • MP407 Loops and Report Writing Basics\\/065 Using an InputBox.mp45.06MB
  • MP407 Loops and Report Writing Basics\\/066 Adding InputBox to Our First Report to ke it Dynamic.mp45.19MB
  • MP407 Loops and Report Writing Basics\\/067 Add a Button to Open Our Report.mp47.75MB
  • MP407 Loops and Report Writing Basics\\/068 Add a Cool Looking Button or Ige to Open Report.mp46.07MB
  • MP407 Loops and Report Writing Basics\\/069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp48.87MB
  • MP407 Loops and Report Writing Basics\\/070 Printable Report Part 2 - Getting Items On Report Sheet.mp411.55MB
  • MP407 Loops and Report Writing Basics\\/071 Printable Report Part 3 - Clearing Last Report.mp412.37MB
  • MP407 Loops and Report Writing Basics\\/072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp410.35MB
  • MP407 Loops and Report Writing Basics\\/073 Using PrintPreview Autotically.mp43.16MB
  • MP407 Loops and Report Writing Basics\\/074 Using PrintOut to Send Directly to Default Printer.mp45.34MB
  • MP407 Loops and Report Writing Basics\\/075 Handling Debug Error When Cancelling InputBox.mp47.10MB
  • MP407 Loops and Report Writing Basics\\/076 For Loop Going Backwards using STEP.mp47.86MB
  • MP407 Loops and Report Writing Basics\\/077 The FOR EACH Loop.mp49.50MB
  • MP407 Loops and Report Writing Basics\\/078 FOR EACH Loop - Practical Examples.mp46.41MB
  • MP407 Loops and Report Writing Basics\\/079 Intro to DO LOOPS.mp47.51MB
  • MP407 Loops and Report Writing Basics\\/080 DO Until.mp42.95MB
  • MP407 Loops and Report Writing Basics\\/081 Loop Until.mp42.28MB
  • MP407 Loops and Report Writing Basics\\/082 DO While.mp42.66MB
  • MP407 Loops and Report Writing Basics\\/083 Loop While.mp41.57MB
  • MP407 Loops and Report Writing Basics\\/084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp42.37MB
  • MP408 EVENTS Worksheet Events de Easy\\/085 Intro to Worksheet Events and Selection_Change.mp46.38MB
  • MP408 EVENTS Worksheet Events de Easy\\/086 Worksheet Activate Event.mp42.44MB
  • MP408 EVENTS Worksheet Events de Easy\\/087 Worksheet Deactivate Event.mp44.35MB
  • MP408 EVENTS Worksheet Events de Easy\\/088 BeforeDelete Event - for Worksheet Deletion.mp42.38MB
  • MP408 EVENTS Worksheet Events de Easy\\/089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp44.86MB
  • MP408 EVENTS Worksheet Events de Easy\\/090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp42.63MB
  • MP408 EVENTS Worksheet Events de Easy\\/091 Calculate Event.mp45.93MB
  • MP408 EVENTS Worksheet Events de Easy\\/092 How to Disable Events on the Workbook.mp42.81MB
  • MP408 EVENTS Worksheet Events de Easy\\/093 Intro to Change Event.mp42.14MB
  • MP408 EVENTS Worksheet Events de Easy\\/094 Change Event with EnableEvents toggle - oid endless loop.mp47.74MB
  • MP408 EVENTS Worksheet Events de Easy\\/095 Change Event Triggered with Custom Range Using Intersect.mp45.54MB
  • MP408 EVENTS Worksheet Events de Easy\\/096 FollowHyperli<x>nks Event.mp46.19MB
  • MP408 EVENTS Worksheet Events de Easy\\/097 Final Thoughts on Worksheet Events and Review Other Events.mp44.50MB
  • MP408 EVENTS Worksheet Events de Easy\\/098 Events Exercise 1.mp415.61MB
  • MP409 WorkBook Events\\/099 Workbook Open.mp48.85MB
  • MP409 WorkBook Events\\/100 Workbook Activate.mp44.64MB
  • MP409 WorkBook Events\\/101 Before Se.mp45.12MB
  • MP409 WorkBook Events\\/102 After Se.mp47.45MB
  • MP409 WorkBook Events\\/103 Before Close.mp49.81MB
  • MP409 WorkBook Events\\/104 Before Print.mp43.53MB
  • MP409 WorkBook Events\\/105 Deactivate.mp43.37MB
  • MP409 WorkBook Events\\/106 NewChart.mp49.22MB
  • MP409 WorkBook Events\\/107 NewSheet.mp44.26MB
  • MP409 WorkBook Events\\/108 Sheet Activate.mp46.83MB
  • MP409 WorkBook Events\\/109 Delete DoubleClick RightClick Calculate Change.mp412.39MB
  • MP409 WorkBook Events\\/110 SheetDeactivate.mp47.02MB
  • MP409 WorkBook Events\\/111 Follow Hyperli<x>nk.mp43.49MB
  • MP409 WorkBook Events\\/112 SheetSelection<x>change.mp44.36MB
  • MP409 WorkBook Events\\/113 WindowActivate.mp43.38MB
  • MP409 WorkBook Events\\/ WindowDeactivate.mp42.36MB
  • MP409 WorkBook Events\\/115 WindowResize.mp47.28MB
  • MP410 Activex Controls on Worksheets\\/116 Activex Controls vs Forms Controls.mp45.84MB
  • MP410 Activex Controls on Worksheets\\/117 Button Click - Wage Calculator.mp46.59MB
  • MP410 Activex Controls on Worksheets\\/118 Keydown Event.mp46.09MB
  • MP410 Activex Controls on Worksheets\\/119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp46.77MB
  • MP410 Activex Controls on Worksheets\\/120 KeyPress Event.mp46.67MB
  • MP410 Activex Controls on Worksheets\\/121 MouseMove Event.mp43.39MB
  • MP410 Activex Controls on Worksheets\\/122 MouseMove Event with Application.Statuar - fun and useful.mp46.41MB
  • MP410 Activex Controls on Worksheets\\/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp411.41MB
  • MP410 Activex Controls on Worksheets\\/124 GotFocus and LostFocus Events.mp42.27MB
  • MP410 Activex Controls on Worksheets\\/125 Use a Checkbox for its VALUE.mp44.54MB
  • MP410 Activex Controls on Worksheets\\/126 Checkbox Event Without a Button.mp42.84MB
  • MP410 Activex Controls on Worksheets\\/127 li<x>nkedCell Property with a Checkbox.mp42.28MB
  • MP410 Activex Controls on Worksheets\\/128 Option Buttons Intro - What is an Option Button and Grouping.mp44.53MB
  • MP410 Activex Controls on Worksheets\\/129 Grouping Alignment and Aesthetics for Controls.mp44.52MB
  • MP410 Activex Controls on Worksheets\\/130 Homede Quiz using Option Buttons and a Command Button.mp47.01MB
  • MP410 Activex Controls on Worksheets\\/131 Compliance Checker for your Forms or Quizzes Part 1.mp46.54MB
  • MP410 Activex Controls on Worksheets\\/132 Compliance check part 2.mp420.01MB
  • MP410 Activex Controls on Worksheets\\/133 SpinButton with Cell A1.mp46.66MB
  • MP410 Activex Controls on Worksheets\\/134 SpinButtons with Textboxes and Numbers.mp49.94MB
  • MP410 Activex Controls on Worksheets\\/135 SpinButton BONUS - Move Textbox Position with SpinButton.mp48.74MB
  • MP410 Activex Controls on Worksheets\\/136 SpinButton with Dates in a Textbox.mp46.85MB
  • MP410 Activex Controls on Worksheets\\/137 Activex Label Control - Basics.mp46.79MB
  • MP410 Activex Controls on Worksheets\\/138 ComboBox - Fill with ListFillRange.mp47.73MB
  • MP410 Activex Controls on Worksheets\\/139 Creating a Dynamic Range.mp48.63MB
  • MP410 Activex Controls on Worksheets\\/140 ComboBox - How to use Multiple Columns.mp46.25MB
  • MP410 Activex Controls on Worksheets\\/141 Using .ADDITEM to Get Specific items in your Combobox List.mp417.73MB
  • MP410 Activex Controls on Worksheets\\/142 Noteworthy Properties of a Combobox.mp412.00MB
  • MP410 Activex Controls on Worksheets\\/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp416.21MB
  • MP410 Activex Controls on Worksheets\\/144 ListBox Basics using Dynamic Range.mp415.37MB
  • MP410 Activex Controls on Worksheets\\/145 Listbox Click event and Dynamic Options.mp47.11MB
  • MP410 Activex Controls on Worksheets\\/146 BONUS - nipulating and Using Multiselect Items in a Listbox.mp410.54MB
  • MP410 Activex Controls on Worksheets\\/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp410.61MB
  • MP410 Activex Controls on Worksheets\\/148 Dynamic ListBoxes Using .ADDITEM and More.mp419.80MB
  • MP410 Activex Controls on Worksheets\\/149 ke and Utilize INVISIBLE Columns - Special Trick.mp46.47MB
  • MP410 Activex Controls on Worksheets\\/150 Using a Scroll Bar on a worksheet.mp44.72MB
  • MP410 Activex Controls on Worksheets\\/151 Pictures on a Worksheet plus using FollowHyperli<x>nk Method.mp413.91MB
  • MP410 Activex Controls on Worksheets\\/152 Toggle Button.mp44.57MB
  • MP410 Activex Controls on Worksheets\\/153 A Brief Note on Alternate 3rd Party Controls.mp42.90MB
  • PDF10 Activex Controls on Worksheets\\attached_files\\118 Keydown Event\\/Key-Code-Constants-Used-With-Key-Down-Events.pdf108.94KB
  • PDF10 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
  • PDF10 Activex Controls on Worksheets\\attached_files\\143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc\\/List-Box-Combobox-LIST-Principles.pdf137.94KB
  • MP411 Userforms - the best thing. EVER\\/154 Userform - Hide Show and Unload.mp49.13MB
  • MP411 Userforms - the best thing. EVER\\/155 Sample Databa<x>se and Creating a Data Entry Form.mp434.48MB
  • MP411 Userforms - the best thing. EVER\\/156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp49.39MB
  • MP411 Userforms - the best thing. EVER\\/157 New Employee Data Entry Form.mp436.52MB
  • MP411 Userforms - the best thing. EVER\\/158 Fort Textbox Numbers as Numerals Clearing out Form upon Submission.mp48.69MB
  • MP411 Userforms - the best thing. EVER\\/159 Set the Tab Order for Userform Controls.mp45.51MB
  • MP411 Userforms - the best thing. EVER\\/160 Set Default Values to ke Data Entry Easier.mp45.47MB
  • MP411 Userforms - the best thing. EVER\\/161 oid Duplicate Employee ID and other Fun Autotion Tricks.mp415.76MB
  • MP411 Userforms - the best thing. EVER\\/162 Edit Mode for Employee Databa<x>se - Part 1.mp437.32MB
  • MP411 Userforms - the best thing. EVER\\/163 Edit Mode for Employee Databa<x>se - Part 2.mp425.05MB
  • MP411 Userforms - the best thing. EVER\\/1 Edit Mode Pt 3 - Adding Autotion and Se Button.mp443.94MB
  • MP411 Userforms - the best thing. EVER\\/165 Userform Report with Filters - Part 1.mp426.37MB
  • MP411 Userforms - the best thing. EVER\\/166 Userform Report with Filters - Part 2.mp415.71MB
  • MP411 Userforms - the best thing. EVER\\/167 Applying the Dynamic Filters to Reports.mp48.46MB
  • MP411 Userforms - the best thing. EVER\\/168 Clear out Last Report.mp46.99MB
  • MP411 Userforms - the best thing. EVER\\/169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp410.65MB
  • MP411 Userforms - the best thing. EVER\\/170 Concluding Thoughts. . ..mp43.36MB
  • MP412 BONUS Section - VBA Functions\\/171 InStr Function - Search for Text Within Other Text.mp414.78MB
  • MP412 BONUS Section - VBA Functions\\/172 The EVALUATE Function - c-Daddy of all functions.mp413.47MB
  • MP412 BONUS Section - VBA Functions\\/173 Sum Function in Excel VBA - EASY.mp47.74MB
  • MP412 BONUS Section - VBA Functions\\/174 Count Function in VBA.mp44.75MB
Latest 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