Chapter 8: Using Functions

In Chapter 4, Working with Procedures, we covered the basic principles of functions. In this chapter, we're building on that knowledge by adding more detail. Your ability to use and apply functions is another steppingstone to becoming a proficient VBA coder.

In this chapter, we will cover the following recipes:

  • Using built-in VBA functions
  • Using worksheet functions
  • Creating custom functions

By the end of this chapter, you will be able to use and create functions in the VBA environment.

Technical requirements

This cookbook was written and designed to be used with MS Office 2019 and MS Office 365, installed on either Windows 8, 8.1, or 10.

If your hardware and software meet these requirements, you have everything you ...

Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.