• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 10: Automating Excel > Creating Custom Functions

Chapter 32. Creating Custom Functions

Using Custom Functions 861

Understanding Custom Function Rules 863

Using VBA Keywords in Custom Functions 863

Documenting Macros and Custom Functions 864

Creating Custom Functions with Optional Arguments 865

Making Your Custom Functions Available Anywhere 867

Although Microsoft Excel includes a multitude of built-in worksheet functions, chances are it doesn't have a function for every type of calculation you perform. Excel's designers couldn't possibly anticipate every calculation need of every user. But they did provide you with the ability to create your own custom functions. In the same way that a macro lets you encapsulate a sequence of actions execute that sequence with a single command, a custom function lets you encapsulate a sequence of calculations so that you can perform those calculations with a single formula.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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