It's always such a pain in the ass to sift through your data and be able to see whats expiring, what's due etc A lot of our data may have...

Excel has both an InputBox and Application.InputBox – it’s easy to tell which is nicer on the eye! There are advantages to both, the...

Here it is! Finally a table of data that can be searched. The VBA component to this is actually minimal. 2 helper columns, a couple of...

Hyperlinking in Excel is painful, way too many clicks, navigation is poor and then the displayed name is a gamble. Here’s a couple of...

Here we have the ability to add to the Context Menu, sometimes known as the right click menu. Most websites are helpful with the below...

There are 3 places that you can put your VBA code that you’ve written or got from the Internet: General module Sheet module ThisWorkbook...

How many times have you been told to back up your work? Now it's simple, this bit of code creates a back up folder in the same folder...