Remove VBA from Excel

Sometimes when you receive an Excel workbook that contains VBA code you may want to remove the code to make the workbook macro-free….

Posted On

Refresh a Userform in VBA

There are virtually limitless possibilities when working with Visual Basic for Applications (VBA). When you start dealing with it, the first thing you…

Posted On

Clear Selection in VBA

As you are probably aware, Visual Basic for Application (VBA) has virtually limitless options for automating Office files, especially Excel. When writing our…

Posted On

Clear Memory in VBA

The Excel VBA Out of memory error (Run-time error 7) occurs when Excel runs out of system resources to continue running the macro….

Posted On