• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using a VBA Macro

VBA macros come in two forms:

  • Command macro— This is code that performs some action that usually has an effect on the program’s environment. For example, the macro might insert text into a worksheet cell or change a Word option. In general, you can think of a command macro as being akin to a program menu command.

  • Function macro— This is code that returns a result. A function often takes one or more values as inputs, manipulates those values in some way, and then sends back the result of those manipulations. In general, you can think of a function macro as being akin to an Excel worksheet function or a Word formula field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint