0101 Create a Self-Adjusting Range
0105 Top 10 List With a Consolidated Other Category
0110: Office 2010 Insert Screenshot
0116 The Excel FORMULATEXT function
0120-1: Banding Rows in an Excel Table
0121: Highlight row and column of selected cell
0122: Ordinal Numbers Suffixes
0123 Unicode and diacritic characters
0201 Freeze Panes and Split Panes
0301: Conditional Color of Shapes
PowerPivot and Conditional Color of Shapes
0401: Numeric and log scale for x axis of Column chart
0610: Draw concentric circles in a
XY Scatter chart ![]()
0702 Highlight matches to current cell
0806 Generate random
numbers in MS Excel ![]()
Conditional formatting icon set to show direction of change
0908: Visualize business dependencies in an Excel worksheet
Property procedures in standard modules
1001: Using Range.Find and implementing FindAll
1002: Exchanging data between Excel and VBA arrays
1011: Array COUNTIF - perform a large number of COUNTIFs on an unsorted array
Index a cell in a multi-area range
Animate a greeting in the form of a stadium wave (also called an audience wave)
1110 TM Excel
Navigator Dynamic Path (Prev Next) ![]()
VB(A) access to web pages and web services
Integrating Google Charts into Excel
Using LINQ to open in Excel the newest file in a folder
Event Procedures - When are they triggered and in what sequence?
Schedule a Subroutine on a Periodic Basis Each day
1003 Minimum, maximum, and smallest values
1004 ByVal or ByRef Parameters
1005 Understanding the ParamArray
1017 Save a global in an Excel workbook
1018 Protect a global variable in another VBProject
1019 Same
function different add-ins![]()
1021: Performing multiple tasks in an event procedure
1022: ByRef Arguments with the Application.Run Method
1023: Display a message for a specific duration
1035 Process all files in a folder and, optionally, in all nested sub-folders
1051: Add userform items on the fly
1053: Extend an object's attributes to coordinate multiple userform controls
1054: List in an
userform all available fonts![]()
1061: Password Userform module
1102: Ease of reuse of modular code