| Name | Description |
| For Developers | |
| Pop up form | Some API’s that make a userform work like a popup style form. |
| Video on a userform | The file uses a few API’s to play, natively (i.e. no Active X dlls), video files on a VBA userform |
| VSTO Addin example | An example of how to write a VSTO addin, a Youtube video, and a sample project |
| Custom Shapes Userforms | In this example we make a complexly custom shaped user form, using some API’s, also shows how to make rounded corners on a form. |
| Do Events | Example of how to use Do Event in VBA – a simple cancel implementation. |
| Fuzzy Logic | A set of UDF’s that implement fuzzy logic algorithm in VBA:
Levenshtein distance Jaro-Winkler Longest Common Subsequence Dice Coeffient |
| Geocoding UDF | Example of how to use Google Map’s API to implement geocoding within Excel. |
| Excel Instance from VB.Net | Example of who to use some methods of the .Net frame work hook into an Excel instance and code against it objects |
| Excel Front Loader | A .Net implementation of a Excel front loader. |
| “Power Users” | |
| Data encryption | An implementation of a simple data encryption algorithm to encode data in a workbook. The VBA code travels with the workbook, and the data will be decrypted at the “other end” if the correct keyword is supplied. |
| Immediate window hook | Ever wanted to use the immediate window from the Excel client window? Not actually a file to download, but the codes in the post. |
| Colour Pallet – Gradients | A tool that lets you create a gradient set of colours and save them to the workbooks colour pallet. XL 2000 to 2003 only! |
| Captionless worksheet | Ever wanted to remove the boards and title bars from a worksheet – not really eh. Well if you ever did, here how!? |
| Inline worksheet help | A few ideas of different ways to show help on the worksheet. |
| Spell Checking Tool | Spell checking is fine in Excel, but typing lots of text into a cell can be a pain. This example uses a userform and does some clever stuff to add spell checking to that form, before posting the result back to the cell – cool. |
| Light Box | Another implication of a “light box” type functions for Excel. This uses shaped and the picture function to produce a live update of some area of a sheet.
NOTE: – Does not work with Excel 2007 + |
| Addins | |
| Colour Manager | An addin that lets user pick colours from a picture an use them in Excel. Also creates a text file to store the new pallet, which can be saved and managed through the addin |
| Calulation Timer | An addin that will time calculation speeds of workbooks, worksheets and ranges. Options to do multiple calculations and work with iterations. |
