VBA and Macros

Copy the Quick Stats Values to the Clipboard


The question came during an Excel seminar in Tampa: Wouldn’t it be cool if you could copy the statistics from the status bar to the clipboard for later pasting to a range?

Learn Excel – “200 Checkboxes in Excel”: Podcast #1871


Catherine is building a risk assessment tool in Excel. She needs to add 200 checkboxes to a worksheet, but this is Back

Learn Excel – “This Cell or That Cell, Not Both”: Podcast #1850


Two questions today in Episode #1850  with a similar solution using a VBA Event Handler. Question 1: Back

Learn Excel – “Bob Umlas Fill 15th & Last of Month”: Podcast #1833


You need to fill the 15th & last of the month. Excel MVP Bob Umlas shows you a trick, from his book “Excel Outside the Box“ in Episode #1833.  Back

Learn Excel – “Bob Umlas Add Sporadic Totals with VBA”: Podcast #1832


Today, a guest appearance by Excel MVP Bob Umlas. Lets say that you have random chunks of Data and you need to add Back

Learn Excel from MrExcel