Index to Excel VBA Freebies

< Back to Search results

 Category: [Excel]  Demo Available 


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


See also: Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions.


See also new resources and reference sheets:

Index to new resources and reference sheets


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)