Function Overloading and UDF in Excel VBA

by

Declare your arguments as Optional Variants, then you can test to see if they’re missing using IsMissing() or check their type using TypeName(), as shown in the following example:

Public Function Foo(Optional v As Variant) As Variant

    If IsMissing(v) Then
        Foo = "Missing argument"
    ElseIf TypeName(v) = "String" Then
        Foo = v & " plus one"
    Else
        Foo = v + 1
    End If

End Function

This can be called from a worksheet as =FOO(), =FOO(number), or =FOO(“string“).

More Related Contents:

  1. Refresh Excel VBA Function Results
  2. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  3. using a sheet in an excel user defined function
  4. Sequence of numbers based on start and end value of 2 cells [closed]
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. How can I create a calendar input in VBA Excel?
  9. Using Google Chrome in Selenium VBA (Installation Steps)
  10. Merge values of column B based on common values on column A
  11. How to use workbook.saveas with automatic Overwrite
  12. How to import a table from web page (with “div class”) to excel?
  13. Range limit conundrum
  14. How do you run a .exe with parameters using vba’s shell()?
  15. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  16. Passing variable from Form to Module in VBA
  17. How to give a time delay of less than one second in excel vba?
  18. Changing the date format to yyyy-mm-dd
  19. Delete all duplicate rows Excel vba
  20. excel to pdf ignores print area and calls printer
  21. Select Newest Record and Create New Table of Unique Values in Excel
  22. Are ActiveX Controls Disabled?
  23. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  24. VBA copy rows that meet criteria to another sheet
  25. VBA Dialog box to select range in different workbook
  26. Delay macro to allow events to finish
  27. Delete all data rows from an Excel table (apart from the first)
  28. Excel Hide/Show all tabs on Ribbon except custom tab
  29. Macros Not Showing Up in Macro Table
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment