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…

|

FORMULATEXT to Display the Formula in a Cell

ByRick

Here is a function that displays the formula in another cell: FORMULATEXT(reference). The argument, “reference”, is the cell address that contains the formula you want to display. This is most useful for documentation purposes.  For example, when you want to print out a spreadsheet with its formulas. If you have spent much time on this…

|

How to Use Objects, Collections, Properties, Events and Methods in Excel Visual Basic

ByRick

1.        What are Objects and Collections? Visual Basic defines a number of what it calls Objects. Examples of Objects are: In object-orientated terminology, Objects belong to Classes. Collections are groups of Objects. Here are some examples of Collections that Visual Basic defines: 2.        The Excel Object Model Excel, too, has objects of its own.  When…

|

How to Copy Text to and from the Clipboard in Excel and Access Visual Basic

ByRick

You can record a macro to copy from and paste to the Excel worksheet.  Easy enough.  But what if you have a value in Microsoft Excel VBA that you want to put on the clipboard for another program?  Or you want your code to get text from the clipboard after you copied it there from…