|
Excel offers right out of the box an enormous variety of functions. So why
does one need VBA macros? With VBA you can accomplish wonders:
. Program your own worksheet functions that are easier to use than complicated
formulas.
. Configure Excel to suit your requirements and achieve greater simplicity and
efficiency
. Structure and simplify complex processes such as filling our forms by means
of
"smart "forms (templates).
. Automate processes that are used frequently. This is particularly useful in
dealing repeatedly with large data sets that must be processes , analyzed, and graphically
displayed. . You can create freestanding Excel programs that display their own
menus, dialogs, and toolbars. This makes it possible to simplify an Excel
application to the point where those unfamiliar with Excel can run the program
correctly.
|