How to create professional VBA custom function and add screen tip to guide users

You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/...
👍 Support: paypal.me/pama...
✉️ Contact: [e-mail]
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
WHAT TO WATCH NEXT
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
* * VSTO (Visual Studio Tools for Office)
• VSTO e01 - Get up to s...
* * Office Add-ins Platform
• Excel Web Add-in E1 - ...
* * Professional UI/UX
• VBA UI UX-1: Build Pro...
* * PDF Automation using VBA
• VBA PDF Automation - R...
* * RibbonX First-Class Ribbon Customization
• RibbonX 01 - Build Fir...
* * Word Automation using VBA
• Real-life Word App Aut...
* * PPT Automation using VBA
• Automate PowerPoint Pr...
* * Custom Menu using VBA
• Custom Menu - E01. Ad...
* * Sharepoint Automation Using VBA
• How to create Custom S...
* * Access DB Automation using VBA
• Create Access Database...
* * SQL Server Automation Using VBA
• VBA and SQL Server - V...
* * Web Automation using VBA
• Extract any Web table ...
* * Excel Password Recovery/Reset
• How to reset forgotten...
* * Errors and Solutions
• How to fix missing Dat...
* * Plug and Play Series
• VBA to get sheets from...
* * Office Quick Tips
• Reset Forgotten VBA Pr...
* * Dark theme VBE
• How to customize VBA E...

[@VBAA2Z]

Interested to become VBA Pro? Here is 100% free guided e-course with Real-life projects.
Sign-up to participate, get assignments and a certificate:-
Sing up link = > bit.ly/3eX8tzl

[@atil2475]

Very useful. I have no idea we could add description or argument info using VBA.

[@VBAA2Z]

you're welcome, thanks for watching.

[@sunil5149]

thanks for the knowledge transfer.

[@VBAA2Z]

you're welcome, thanks for watching.

[@khuramshahzad3936]

Is it possible to call back a user defined function like these on a custom ribbon control?
Like other built in excel formulas.

[@VBAA2Z]

yes you can. try like this and let me know if have any questions.
ruclips.net/video/IYXzMvKO51M/видео.html

[@mahanpourhosseini871]

my function has 4 arguments. how can i add all of 4 argument descriptions. yours only have one. thanks

[@VBAA2Z]

simply update arg(0)
to arg(1) if 2 arguments, arg(2) if 3 arguments
arg(0) = "first argument desc."
arg(1) = "2nd argument desc."
arg(2) = "3rd argument desc."
and so on

[@mahanpourhosseini871]

@@VBAA2ZThank you so much. i have another question and didnt find any answer. how can i define a optional argument for a function so that if i leave it empty the function does not give #value error. like "FV" or "Type" arguments in PV function which as you can see their fonts are not bold like other arguments and they could be left empty.

[@VBAA2Z]

that needs to be handled within your code using if x = "" or if x is nothing etc...

[@flightszym290]

I use the keyword Optional for this problem. The syntax is e.g.:
Function my_func(a1 As Range, Optional a2 As Double = 1, Optional a3 As Single = 2)
a2 and a3 are optional and when not specified become 1 for a2 and 2 for a3.
If you don't want to specify default values and handle missing arguments situation in another way you can write:
Function my_func(a1 As Range, Optional a2 As Double, Optional a3 As Single)
and check if a2 or a3 is missing by the IsMissing(argument) function.

[@TinyGiraffes]

This was interesting but the Application.MacroOptions doesn't actually change anything about my Function

[@EganathanPushpakharan-uz9po]

Is it possible to create UDF Argument Custom options? Eg. VLOOKUP shows TRUE or FALSE for the last argument [range_lookup]

[@VBAA2Z]

Check this out ruclips.net/video/z3cbAh7CzMo/видео.html

[@EganathanPushpakharan-uz9po]

@@VBAA2Z Thanks very much!