Write A VBA Macro To Display A Pop Up Message When A Specific Sheet Is Activated – Macro Mondays
Hello Excellers. Today let's look at how to write an Excel Macro with some simple VBA to display a pop-up message box when a specific worksheet is activated. This method can be useful if you need...
Pad Numbers With Zeros Using The LEFT Excel Function – Formula Friday
Hello, Excellers welcome to another Excel #formulafriday. Today I want to share with you a solution to a problem that is really quite common and I get asked about from time to time. How do you...
Macro Monday – Insert A Page Break After Specified Number Of Rows with VBA
Hey Excellers, it is indeed time for some more #macromonday fun. Today's Macro will insert a page break in our Excel sheet after a specified number of rows. This is a piece of code I used...
Hi, Excellers welcome again to my #formulafriday blog post series. Today I want to share with you a great little hack for your chart axis labels. If you find yourself with a shortage of real...
How To Use The VBA BeforeClose Event To Remind Users To Backup Their File – Macro Monday
Hello fellow Excellers and yes it is #MacroMonday time again. Time for some cool Macro fun. Today let's look at the VBA BeforeClose event for a workbook. This event occurs before the workbook...
Highlight Weekend Dates In Your Data Set. Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's take a look at using conditional formatting along with an Excel formula to highlight dates in our data set that fall on a...