excel

Update all Pivots and Graphs – One Button

Update all Pivots and Graphs - One Button This code will Update all pivot tables and pivot graphs in the...

Forums

Use Buttons to Navigate Sheets

This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From...

Open Internet Explorer Once or Loop – VBA

You can attach this code to a button that can open Internet Explorer and navigate to a set website. Sub...

Mario Theme Song – VBA

Moving on from the Computer beep from excel, this code will play the Mario Theme song, now it isn't 100%...

Randomly Quit Excel – VBA

Annoying, or clever, you decide how you use it! When Excel is opened, it sets a variable (Close_Var) equal to...

Automate start and end of the month date

This code works along the same as the First and Last Month Dates but is for a rolling 12 month....

Data Validation Based on Cell Value

You can add a Data Validation list based on the value of another cell. For this example, it uses the...

1 min read

• Core Updates

So far so good

8 years ago MoDAdmin

So far, the migration from old to new is going well, taking time but going well! You will see the...

First and Last date of the last month

First and Last date of the last month Extract just month from a cell - Here's how Adding years, months...