This bit of code will count how many formulas you have used in a workbook, will display a message box...
vba
This is some simple code to either "Reset" a user entry workbook or to clear cell values before / after...
Developer and VBA Starting Point Firstly you will want to add in the Developer tab to your excel ribbon. File...
SQL Query Into to VBA Language - The Converter This process will enable to you build a SQL query to...
This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From...
You can attach this code to a button that can open Internet Explorer and navigate to a set website. Sub...
Moving on from the Computer beep from excel, this code will play the Mario Theme song, now it isn't 100%...
Annoying, or clever, you decide how you use it! When Excel is opened, it sets a variable (Close_Var) equal to...
So far, the migration from old to new is going well, taking time but going well! You will see the...