Macros: Making Excel even more capable

There are several hundred functions on Excel, which can mostly be combined to produce thousands more, but sometimes even they cannot cope with requirements.

Excel’s programming language, VBA (Visual Basic for Applications) is there to help you achieve the missing capabilities, by allowing you to program Excel. Routines can be written, dialogue boxes displayed, and data manipulated.
You can even write your own Excel functions.

A very popular use is to automate oft-repeated operations, which are generally called macros, introduced by Lotus in the 1980s.

These can be written, but the most straightforward and popular method is have Excel record them for you.

About spreadsheetexpertblog

Working as a computer professional since 1983, on projects varying in size from one person to multi-million pounds. Working on Excel projects since the mid 1990s.
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s