VBA code to contol Form Control checkboxes

Checkboxes are one of the easiest ways to create interaction with users.  Controlling them with VBA makes them more flexible and more useful in Excel applications. Here is a collection of the most common code snippets and settings. Create Check Boxes The following code will create a checkbox Sub CreateCheckBoxes() ‘Create variable Dim chkBox As Read More

List unique or duplicate values with Excel formulas

The Excel team recently announced new dynamic array formulas, which can create unique lists, sort and filter with a simple formula.  These new formulas are being rolled out to Office 365 subscribers over the next few months.  However, not everybody has the subscription and will upgrade when it is sensible for their business, often combining Read More

Spreadsheet Day 2018

Happy Spreadsheet Day! 17th of October is Spreadsheet Day, the day each year when we celebrate… you guessed it… spreadsheets. VisiCalc, the first spreadsheet application, shipped on 17 October 1979. Originally it was only compatible with the Apple II and cost $99. I don’t know if VisiCalc had formulas and functions. Sometimes I wonder what Read More

Excel Tables – Absolute cell & column references

One of the first things we learn in Excel is the magic of the $ symbol.  It freezes the row or column, so when copying a formula, the cell reference does not change.  With the introduction of Tables came a different (and more semantic) way to reference cells, called structured references.  However, structured references don’t Read More