Show Expiry Dates Across Multiple Columns
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...
InputBox vs Application.InputBox and testing for cancel button
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...
Searchable Table!
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 the easy way!
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...
Add to Right Click Menu (Context Menu)
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...
Where do I Paste VBA Code
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...
Backup your workbook!
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...
