Skip to main content Skip to book tools
MyEducator Home Page
  • Business Programming with E...
    • Chapter 11
      • Title Page
      • Introduction
      • Chapter 1: Getting Started – Learning About Macros
      • Chapter 2: Recording and Editing Macros for Complex Tasks
      • Chapter 3: Understanding Objects and Collections
      • Chapter 4: Writing Simple Macro Procedures
      • Chapter 5: Working with Ranges and Cells
      • Chapter 6: Understanding Data Types, Variables, and Constants
      • Chapter 7: Operators and Expressions
      • Chapter 8: Built-In Functions in VBA and Excel
      • Chapter 9: Using VBA Functions to Manipulate and Compare Strings
      • Chapter 10: Formatting Data Values
      • Chapter 11: Creating and Using Your Own Functions in VBA
      • Chapter 12: Creating Excel User-Defined Functions
      • Chapter 13: Making Decisions in VBA: Flow Control
      • Chapter 14: Repeating Actions in VBA: Loops
      • Chapter 15: Debugging and Testing VBA Code
      • Chapter 16: Working with Excel's Built-In Objects and Collections
      • Chapter 17: Working with Chart Objects
      • Chapter 18: Using Excel's Built-In File Dialogs
      • Chapter 19: Working With Pivot Tables
      • Chapter 20: Advanced Topics for Variables, Constants, and Data-Types
      • Chapter 21: Defensive Programming: Preventing Errors Before They Happen
      • Chapter 22: Error Handling
      • Chapter 23: Creating Libraries and Whole Programs: Modular Programming Techniques
      • Chapter 24: Creating and Using Arrays
      • Chapter 25: Sorting and Searching Arrays
      • Chapter 26: Creating Custom Dialogs with User Forms
      • Chapter 27: Creating Custom Ribbons for Your Workbooks
      • Chapter 28: Importing Data From A Database
      • Chapter 29: Using VBA to Control Internet Explorer
      • Chapter 30: Automating Solver With VBA
      • Chapter 31: Using the FollowHyperlink Method
      • Chapter 32: Using Event Procedures
      • Chapter 33: Creating, Deploying, and Controlling Add-Ins
      • Chapter 34: Creating Your Own Data Types
      • Chapter 35: Creating Your Own Classes and Collections
      • Chapter 36: Managing Files and Reading & Writing Text Files with VBA
      • Chapter 37: Working With Other Applications
      • Chapter 38: Using VBA to Send E-Mail with MS Outlook and Google Mail
      • Chapter 39: Using VBA to Control MS Word
      • Chapter 40: Using VBA with Google Docs
      • Chapter 41: Using VBA to Control MS PowerPoint
    • Login
    • Chapter 11: Creating and Using Your Own Functions in VBA
    • 11.1 Introduction & ResourcesThis is the current section.
    • 11.2 Understanding Function Procedures
    • 11.3 Creating Function Procedures
    • 11.4 Using Function Procedures in Visual Basic for Applications
    • 11.5 Designing Function Procedures
    • 11.6 Understanding Recursion
    • 11.7 Summary
    • 11.8 FAQs

    U
    U
    U
    U
    U
    U
    U
    U
    Copyright © 2025 MyEducator. All rights reserved.
    Need Help?