Extract summary data from closed files
Black Scholes Formula
Self-Restoring Application Interface Lock
Replace Function for VB5 (Office 97)
Incremental number for saved files
FindAll Method - Extension of Excel VBA Find and Find Next Method
Highlight Current Row and Column
Search Knowledge base and return hyperlinks to items
Floating listbox to navigate and handle visible Sheets
Search for a string in all Worksheets. Navigate back and forth. Highlight cells.
Show estimated time left in statusbar
Multiline TextBox: Restrict accidental exit while DownArrow/UpArrow through the text
Flag Unique and Duplicate entries
Two Validation List with automatic updating of first data of second validation list
Adobe Acrobat PDF file import
Tornado Charts
Extract and Transfer Paragraphs
Difference Between Ranges
Add Leading Zeros
Always Paste Special
Use a spinbutton to change items in listbox and update sheet that populates listbox
Base to decimal conversion function
Encrypt and decrypt strings using a Xor algorithm
Disable Cut, Copy, Paste
Decimal base conversion function
Userform with doubleclick filled with values
Trigger a macro when a formula result changes
Email Workbook with Message (Uses xlDialogSendMail & Outlook Express)
Setup & Print All Sheets In A Workbook
Execute different line of code with second click of command button
Audit formulae as you select cells
CheckBox Alternative
Modify UserForm Appearances under Run-Time Conditions
Mac: Import / Export VBE Components
Protect cell or cells on sheet without protecting sheet
Simple Floating Toolbar
Delete unused PivotItems from the PivotTable filter list
Autofiltering with date
Consolidate data layout for printing
List contents of the 'Windows Updates' history.
Coloring listviewitems based on a condition
Photo Handler
Hyperlink list of modified excel workbooks
Easily open any file, folder, or webpage by using the FollowHyperlink Method
Force User to Enable Macros
Create the Personal.xls workbook and import files
Tracking Changes With Comments
Listbox filled with matching names in sheet two from partial searchstring in sheet1
Breaking news on Excel
Function to Concatenate a Range, with Optional Delimiter, Value Type and Skip Blanks
Using custom format to display text
Delete then restore all data tables in a workbook
Fill listbox with redimensionable array
Replace Defined Names In Formulas With Actual Cell References
Add comments to cells by double clicking the cell.
Make specific cell blink based on a condition
Calculate High-Precision Square Root using Decimal Data Type
Query Access database using ADODB and write results to spreadsheet
Converting hr:min to Decimal Hours on the Fly
Automatic Highlighting Using Conditional Formatting
Email Activesheet in Body of Mail Using Default Mailer.
Mutually Exclusive Cells (Toggling Cells)
Full path and sheet name in Windows caption
Collapse Excel inwards and exit
Expand into view a Modeless UserForm.
Avoid Unnecessary Loops through cells
Add date or time to a cell when a row (or column) is updated
Create a list of RGB and HEX codes
Translate RGB codes to HEX #rrggbb
Wildcard search for the wildcard characters * and ?
Highlight Row / Column of Filled Cells
Automatic Directory File List
Add/Remove Bullets-Dashes
Auto Row Numbering
Automatic Highlighting Using Autoshapes
Alphabetized Table of Contents with Toolbar Buttons
Cut and Paste into formatted cells
Copy Updated Sheet From Closed Workbook
Bulk File Copying, Renaming, Moving Template
Navigate Back to Previous Locations in a Workbook.
Remove or Reduce Internal Blanks In A String
Combine All Workbooks from One Folder Skipping Blank Sheets
Copying and Moving files of any type using Excel VBA
Fill combobox with ordered list
Hightlight all protected cells
One Line Find
Delete Rows Based on Column Criteria
Search directory and sub folders for Excel files
Terminate a running process.
Using workbook events to control the visibility of defined toolbars/menus
Create Text Files With Any Delimiter
Create a custom "Worksheet Find" toolbar
Create menu for use in international environment distributed as xla
Add Numbered Sheets From Template
Win/Mac Scalable Calendar Control
Set a Trial Period For Use of Your Project
CheckBox utility
Create customised random test data
Working with the last data values in Rows or Columns
Multi Filtered search and create
Sort and adjust named range when data is inserted, deleted or changed.
Search workbook by regions (Quick-search)
ListBox Control - Determine the Order in Which Selections are Made
Sample Data Maker
Search all worksheets for word/phrase and list results with hyperlink to cell.
Filter a sheet and copy results to another sheet
Directory and File Lister-Includes Sub Directories & Files
Save Cells Previous Value in a Comment
Clear Built In Document Properties
Create a custom worksheet by hiding unwanted rows and columns
Reduce Excel File Size
Combine All Data From All Worksheets in All Workbooks in a Specified Directory
Concatenate using first space before address as delimiter
Parse a Range Address Into Its Column and Row Components
Acronym Generator
Create different Email Messages based on Contents of a cell
Play Different Beeps
Function to return random sample, with or without replacement
Getting the Username
Open All Workbooks In a Folder
Check if Named Range exists
Test a range for any kind of data
Find the pairs of cells of a selected range whose sum equals to a provided value
List Environ info
Format cell text under VBA control
Sequence Counter
Insert a hyperlink to a Word Bookmark
Show The Windows Search Results Dialog
Test For Selected Cells Count
Creating a fixed width textfile from a worksheet
Diabetics Log
Run a Powerpoint Show From Excel
Email Link on a Userform
Faster Page Setup
Remove the Old File
3 ways to put a cell value in a page header
Return Named Range Name from Refers To Value
Last Dynamic Filled Row
standardized Excel headers and footers
Count Text Cases
Charts - Delete out-of-bounds data labels
Batch Change Workbook Properties
Save and Close All Open Workbooks
Update Project Workbooks Using Custom Document Properties
Dynamic Charting Range
Delete Hyperlinks, Links, Formulas From Worksheet
Convert Text to Title Case
Find First or Last Populated Column in a sheet
Find First or Last Populated Row in a sheet
Delete all named ranges in a workbook containing a #REF! error
List all Checked GUIDS
Install Specific Add-in
Copy Chart Sheets to a New Workbook
GetOpenFilenameFrom function
Delete Hyperlinks, Links, Formulas From Workbook
Add a sheet with today's date
Create a unique list and count of items from an unsorted list
Create a temporary UserForm to show the user's Colour Palette
Solver Add-in Installation/Reference Through VBA
Parsing a chemical formula and determining the atomic counts
Function to check if workbook is open or not.
align (resize and move) charts in a worksheet
Store Values in Custom Document Properties
Store Values in a Defined Name
EMail active workbook using MAPI
Create a Delay
Select Program to Open a File
Redefine All Range Names
Print all embedded charts
Prevent Cell Selection / Scrolling
Excel sheet sorting
Prevent Sheets Being Added
Prevent Row / Column Removal
Change formula reference type
Open The Visual Basic Editor Programmatically
Clear Recent Documents List
Workbook Name Minus the .xls
Zoom in on sheet when a specific range is selected
Eliminate excess spaces from selection
Listbox-Show Picture on Click-Select Data on Double-Click
Restrict User To 1 Sheet
Determine if a formula is a UDF
Click Name in Listbox to Select Data in Sheet
Delete all ActiveX Controls from a sheet
Achieving Target Value in a cell
Website Hyperlink on a form
Show Windows "About" dialog
Read Text File into ListBox
Updated StatusBar Message From Online Workbook
Status Bar Messages
User must fill in certain cells before they can close the workbook
Find and Link to Cells
Create a Custom Desktop Shortcut
Concatenate all Data in Range (Function)
Retrieve table content from a web page to Excel
Hide horizontal and vertical scoll bars
Remove Carriage / Paragraph Returns from Within Cells
Pre-determined text entered in cell when number is entered.
Write User Name Stamp on Sheet on Save.
Write Date Time Stamp on Sheet on Save.
Filter based on selection in two columns and copy to a new sheet
Change page setup (and printers) with userform interface
Color several multi-column sections at one time based on criteria
Loop through selection and act based on cell value
Insert a new sheet each time the workbook is opened
Maximize Excel When Workbook is Opened
List all Built In Document Properties in an Excel worksheet
Exit Windows - (Log-Off, Reboot, or Shut Down)
Clear contents of user input range on workbook open
Highlight all formula cells on the activesheet that contain both cell refs and constants
Change Column A and rest of row follows
Unprotect all colored cells only
Check if any sheets in workbook are protected
Click any cell of row for a Checkmark in Column C
Ultra Fast Large Scale Replace
Data Entry - Multiple Column List Box
Extract Data From Closed Workbooks
Delete Conditional Formatting
Userform Calendar Control
Code for a self-destructing Workbook
Force user to enter a value in a cell before leaving the worksheet
Test procedure run time
Return to the user's active cell/selection after code execution finishes
Return IP Address into cell A1
Changing printers in Excel
Check If a File Is Already Open
Go To Previous Worksheet / Go To Next Worksheet
Lock Excel if No Activity Then Log-off if Wrong PIN Entered
PMT function but periodic payments increases yearly or per cut-off
Selectively permit access to spreadsheet through choice of password.
Code Rows Only as Required
Create various borders for a range
Display and print cells containing more than 1024 characters
Get Userform Metrics
Delete Duplicated Entries In Cells
Run Once Then Delete Code
Using Functions to Get a Range
Hide the Gridlines
Hide Empty Rows, Unhide Others
Run Once Code (With Option)
Sorting a range of coloured cells
Used Region Function
Animated Word Art
Import notepad and wordpad text files
A Better Sheet Management Function
Shades rows and/or columns in a worksheet for improved visibility
Delete all charts in a sheet or workbook
Position Any Cell Top Left in Window
Set minimum column width for Autofit columns
Split text between cells in a column as you go.