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

preview_player
Показать описание
You can now support by buying any of the Projects or Source Code.

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
WHAT TO WATCH NEXT
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

* * *  VSTO (Visual Studio Tools for Office)

* * * Office Add-ins Platform

* * * Professional UI/UX

* * * PDF Automation using VBA

* * * RibbonX First-Class Ribbon Customization

* * * Word Automation using VBA

* * * PPT Automation using VBA

* * * Custom Menu using VBA

* * * Sharepoint Automation Using VBA

* * * Access DB Automation using VBA

* * * SQL Server Automation Using VBA

* * * Web Automation using VBA

* * * Excel Password Recovery/Reset

* * * Errors and Solutions

* * * Plug and Play Series

* * * Office Quick Tips

* * * Dark theme VBE
Рекомендации по теме
Комментарии
Автор

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

VBAAZ
Автор

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

atil
Автор

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

khuramshahzad
Автор

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

mahanpourhosseini
Автор

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

TinyGiraffes
Автор

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

EganathanPushpakharan-uzpo