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.
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 ...