Microsoft Office Tutorials and References
In Depth Information
Chapter 25: VBA Custom Function Examples
25
VBA Custom Function
Examples
In This Chapter
Simple custom function examples
A custom function to determine a cell’s data type
A custom function to make a single worksheet function act like multiple functions
A custom function for generating random numbers and selecting cells at random
Custom functions for calculating sales commissions
Custom functions for manipulating text
Custom functions for counting and summing cells
Custom functions that deal with dates
A custom function example for returning the last nonempty cell in a column or row
Custom functions that work with multiple worksheets
Advanced custom function techniques
This chapter is jam-packed with a wide variety of useful (or potentially useful) VBA custom
worksheet functions. You can use many of the functions as they are written. You may need to modify
other functions to meet your particular needs. For maximum speed and efficiency, these
Function procedures declare all variables that are used.
 
Search JabSto ::




Custom Search