| 1 |
Auto-Run-Macros |
| 2 |
Excel AutoFilters in VBA using Dates |
| 3 |
Criteria for VBA filters |
| 4 |
Excel VBA AutoFilters |
| 5 |
2 Criteria VLookup for Excel |
| 6 |
3 Criteria VLookup for Excel |
| 7 |
4 Criteria VLookup for Excel |
| 8 |
5 Criteria Vlookup for Excel |
|
|
Excel 2007 Alternative To File Search |
| 10 |
Add Excel Worksheets in Month/Monthly Order |
| 11 |
Add Excel Worksheets in Numeric Sequence |
| 12 |
Add Worksheets to Excel via VBA |
| 13 |
Find Feature to Find 3 Matching Criteria in 3 Columns in Excel |
| 14 |
List/Return Difference Between 2 Cells Containing Comma Separated Strings |
| 15 |
Use Array Elements To Fill a Range With Headings |
| 16 |
Automatically Add Date, Time or Date & Time |
| 17 |
Display Excel AutoFilter Criteria |
| 18 |
Use AutoFilter in Excel VBA to Filter by Date & Time |
| 19 |
Speed up Excel VBA Macro Code |
| 20 |
Functions To Determine Excel Calculation Status & Mode |
| 21 |
Change Text to Upper Case or Proper Case |
| 22 |
Color or Format a Formula Referenced Cells - Precedents |
| 23 |
Copy Multiple Column & Row Records Into Single Row Records |
| 24 |
Loop Through Controls on a UserForm |
| 25 |
Convert a String or Number to Boolean |
| 26 |
Convert a String to a Byte Data Type |
| 27 |
Convert to a Currency Data Type |
| 28 |
Convert to a Date Data Type |
| 29 |
Convert to a Decimal Data Type |
| 30 |
Convert to a Double Data Type |
| 31 |
Convert to a Integer Data Type |
| 32 |
Excel VBA: Convert to a Long Data Type |
| 33 |
Convert to a Single Data Type |
| 34 |
Convert to a String Data Type |
| 35 |
Convert Excel Text To Upper Case |
| 36 |
Convert Numbers to Words/Text |
| 37 |
Excel VBA: Convert to a Variant Data Type |
| 38 |
Count Or Sum Specified Number In a Single Cell |
| 39 |
VBA Count of Each Item in a List |
| 40 |
Count Distinct Values Once/Count Repeated Entries Only One Time |
| 41 |
Custom Excel Function (UDF) that will Count Words in Excel |
| 42 |
Create a Worksheet Calendar |
| 43 |
Excel: Convert Currency Number to Words/Text |
| 44 |
Examples & Usage Of Excel VBA Custom Functions |
| 45 |
Add Quick Access to Excel Custom Lists |
| 46 |
Create Custom Menu Items in Excel VBA |
| 47 |
Cursor Movement Shortcut Keys |
| 48 |
Index and match reference sheet |
| 49 |
Add/Subtract Dates In Excel VBA |
| 50 |
Debug Excel VBA Macro Code |
| 51 |
Excel VBA - Excel Macros |
| 52 |
Delete Module After Running VBA Code |
| 53 |
Deleting Excel Named Ranges |
| 54 |
Delete Excel Sheet Event Code Macro |
| 55 |
Delete Excel Workbook Event Code |
| 56 |
Matching ComboBox Controls |
| 57 |
Adding a Description and Category to your User Defined Functions in Excel |
| 58 |
Excel VBA: Disable Cut/Copy in Excel Workbooks |
| 59 |
Excel VBA: Does Workbook Exist |
| 60 |
Do While Loop, Repeat a Block of VBA Macro Code |
| 61 |
Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them |
| 62 |
Excel Calendar |
| 63 |
Tick Cell Upon Selection |
| 64 |
Excel VBA: Number of Specified Days in a Specified Month |
| 65 |
Excel VBA: Code to Locate Two Matches in 2 Separate Columns |
| 66 |
Excel VBA: Does Cell Have Formula |
| 67 |
Excel VBA Macro: Determine Which Button, Control or Command Button Was Clicked |
| 68 |
Excel VBA: Macro Code To Run Macros On Protected Worksheets & Sheets |
| 69 |
Excel VBA: Stop Screen Flickering in Recorded Macros and Speed up Your Code |
| 70 |
Excel Ranges: Finding the Last Cell in a Range |
| 71 |
Excel: Get File Name From User to Open Workbook Or Save Workbook |
| 72 |
Excel VBA Runtime Errors & Preventing Them |
| 73 |
Sheet/Worksheet CodeNames |
| 74 |
Automatically Run Excel Macros via Workbook & Worksheet Events |
| 75 |
Excel: Password Protect/Unprotect All Excel Worksheets in One Go |
| 76 |
Excluding Headings/Headers From the Current Region/Table |
| 77 |
Excel: Get Text From Excel Cell Comments |
| 78 |
Excel: Get Data From Closed Excel Workbooks |
| 79 |
Excel: Get Last Word From Text String |
| 80 |
Extract Number From Text String |
| 81 |
Excel VBA: Extract Word From a Text String |
| 82 |
Excel VBA: Find Number Between 2 Numbers |
| 83 |
Find Method to Find Dates |
| 84 |
Excel VBA Find Method |
| 85 |
Force Text to Upper Case/Proper Case |
| 86 |
Used to Loop Through a Collection or Array |
| 87 |
For Loop |
| 88 |
For Loop Step |
| 89 |
Convert Excel Formulas from Relative to Absolute |
| 90 |
Custom Excel Formulas - User Defined Functions/Formulas |
| 91 |
Parse/Extract File Name from Full File Name and Path |
| 92 |
Excel: Get Maximum Number Between 2 Numbers |
| 93 |
Group Excel Worksheets/Sheets by Color |
| 94 |
Hide Pivot Table Fields Pivot Items by Criteria |
| 95 |
Excel: Get Underlying Hyperlink Address |
| 96 |
Excel VBA: Create a List of Hyperlinks |
| 97 |
Excel VBA: Gather User Data/Input via an InputBox |
| 98 |
Inputbox in Excel VBA |
| 99 |
Is Workbook Open/Workbook Exists/Worksheet Exists/Auto Filter/How Many Pages Printed |
| 100 |
Excel VBA: Create Worksheets for Each Item in an Excel Table of Data |
| 101 |
Return Last Chosen Day of Given Month |
| 102 |
Find & Return The Last Used Cell On An Excel Worksheet Or Column |
| 103 |
Limit Scroll Area on an Excel Worksheet |
| 104 |
Filter ListBox Data to Meet a Specified Criteria |
| 105 |
Move ListBox Items Up & Down |
| 106 |
FREE Excel Add-in: Excel List to Table Creator |
| 107 |
Loop All Worksheets/Sheets in Workbook & Apply Code |
| 108 |
Excel VBA Loops Explained |
| 109 |
Loop Through a Folder of Excel Workbooks |
| 110 |
Mask Date Entry in Excel |
| 111 |
Mask Time Entry in Excel |
| 112 |
Minimize/Maximize Button to a UserForm |
| 113 |
Excel VBA Macro Codes Tips & Tricks |
| 114 |
Excel Message Box (MsgBox) Function |
| 115 |
Multi Select ListBox |
| 116 |
Return Date of the First, or nth Day of Month |
| 117 |
Excel VBA: Hide/Show Pivot Table Field Items |
| 118 |
Printing PivotTables & PivotCharts |
| 119 |
Refresh Pivot Table via VBA |
| 120 |
Prevent Save As in Excel |
| 121 |
Prevent Excel Being Saved With Another Name |
| 122 |
Prevent Save Prompts in Excel |
| 123 |
Excel VBA: Determine Number of Pages to be Printed |
| 124 |
Protect/Lock Excel VBA Code |
| 125 |
Excel: Generate Unique Random Numbers |
| 126 |
Get Range Address of a Excel Named Range |
| 127 |
Excel: Remove Duplicates in Excel |
| 128 |
Restricting Excel VBA Loops |
| 129 |
Return Excel Color Index Number or Color as Text |
| 130 |
Return an Excel Worksheet/Sheet Name to a Cell |
| 131 |
Excel: Reverse Cell Text/Content |
| 132 |
Add Excel Right Click Menu |
| 133 |
Delete Rows Meeting Condition/Criteria |
| 134 |
Worksheet Change Event: Automatically Run Excel Macros When a Cell Changes |
| 135 |
Saving an Excel Workbook/File as a Cell Text |
| 136 |
Select Case Statement in Excel VBA |
| 137 |
Send Emails From Excel |
| 138 |
Working With Shapes In Excel VBA |
| 139 |
Create a Sheet Index of Excel Worksheets |
| 140 |
Custom Function to Calculate Sliding Scale Tax |
| 141 |
Excel: Please Wait Message for Slow or Long Running Excel Macros |
| 142 |
Sort by Color In Excel |
| 143 |
Sort Alphanumeric Text |
| 144 |
Sort an Array |
| 145 |
Sort Excel Worksheets/Sheets in Excel |
| 146 |
SpecialCells Method |
| 147 |
Optimize Slow VBA Code. Speeding Up Slow Excel VBA Code |
| 148 |
Hide Excel Formulas |
| 149 |
Stop Screen Flicker in Excel |
| 150 |
Password Protect Worksheet From Viewing |
| 151 |
2 Excel Functions/Formulas to Count/Sum Excel Cells by Color |
| 152 |
Sum/Count Cells By Fill Or Background Color in Excel |
| 153 |
Sum Excel Ranges Diagonally |
| 154 |
Excel Function That Sums Every Nth Cell In a Specified Range |
| 155 |
Sum Values In Excel Meeting Up To 5 Criteria/Conditions |
| 156 |
Excel Custom Function: Sum Top/Bottom X Numbers In 1 Column or Row |
| 157 |
Show/Hide a Custom Toolbar & Remove/Restore Excel's Toolbars |
| 158 |
Track/Report User Changes on an Excel Worksheet/Workbook |
| 159 |
Transfer Multi-Select ListBox To Range Of Cells |
| 160 |
Transpose Rows Into Columns |
| 161 |
Excel Lookup nth Occurrence/Instance |
| 162 |
Add Excel UDF/Custom Function to a Category & Add a Description |
| 163 |
The Ultimate Excel Lookup Function |
| 164 |
Update Links in Excel |
| 165 |
Stop UserForm From Closing via X |
| 166 |
Excel VBA Code For Excel UserForms & Controls |
| 167 |
TextBox for Numbers Only |
| 168 |
TextBox for Text Only |
| 169 |
Using Variables in Excel VBA Macro Code |
| 170 |
Excel VBA Variables Scope and Lifetime |
| 171 |
Worksheet Names Stored In Cells For Excel Formula References |
| 172 |
Prevent Excel VBA Macro Code Being Case Sensitive |
| 173 |
Excel: Delete/Deleting Blank Rows With Excel VBA |
| 174 |
Excel VBA Events |
| 175 |
Excel VBA Intersect Method |
| 176 |
Excel VBA Loops |
| 177 |
Excel Visual Basic Editor Environment Tips & Tricks |
| 178 |
Vlookup Across Excel Worksheets |
| 179 |
Returning the Workbook Path for Excel Workbooks |
| 180 |
Working With Excel Worksheets In Excel VBA Macro Code |
| 181 |
VLOOKUPS and LOOPS using VBA code index |
| 182 |
Excel VBA Evaluate Method. Excel Formulas/Functions In Macro Code |
| 183 |
Lookup Any Occurrence in Any Table Column |
