Similar Posts

| |

Built-in Functions in Excel Visual Basic for Applications (VBA)

ByRick

Before Excel 2003, you could get a complete list of Visual Basic Functions by looking in Visual Basic Help > Contents > Functions. In Excel 2010, entering “Functions” into the Help Search box produces nothing useful.  Using a specific category, e.g. “Math Functions”, may be more productive.  Please be aware of what references to “Excel…

|

Should I use a VBA Macro Function or Call a Worksheet Function?

ByRick

If the function you want to use exists in Excel VBA, use that.  It will be faster and cleaner, and work in all Microsoft Office programs, not only in Excel.  Here is a full list of Excel VBA Functions.  If the function you want is not there, but exists in the Worksheet, you may be…

Examples of Visual Basic Code for Controlling Excel

ByRick

A major reason to program Excel Macros is to get the spreadsheet to do something.  This post is a goldmine of useful Excel Visual Basic code for talking to Excel.  You can get use the routines stand-alone.  Alternatively, you can save retyping or copy-pasting: Get the file Macros.xlsm free of charge from us. 1.        Table…