Top 10 List With a Consolidated Other Category
0110: Office 2010 Insert Screenshot
0120-1: Banding Rows in an Excel Table
0121: Highlight row and column of selected cell ![]()
0122: Ordinal Numbers Suffixes
0301: Conditional Color of Shapes
PowerPivot and Conditional Color of Shapes
0401: Numeric and log scale for x axis of Column chart
0702
Highlight matches to current cell ![]()
Conditional formatting icon set to show direction of change
Property procedures in standard modules
1001: 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)
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
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