u/OkCod4636

I started creating custom functions in my excel workbook but i want to add a tooltip so i don’t have to go back into VBA to read my comments on what the function does.

I have been able to create add descriptions using Application.MacroOptions, which i need to run every-time excel is reopened
And show descriptions within the function box (double clicking FX)

What I’m actually looking for is the ability to add detailed argument descriptions, the same way Excel’s built-in functions do.

Examples of what I want:
• In the IF function you see:
logical_test, value_if_true, value_if_false
• In VLOOKUP you see descriptions like:
range_lookup → TRUE = approximate match, FALSE = exact match

Is there a way to add these per-argument tooltips/descriptions to my own UDFs so they appear in the Function Arguments

Can anyone guide me or explain how to add a tooltip to my custom functions ?

Thanks in advance!

What do you reckon to be the average Tanzanian dream?

My speculation is
- Having a stable income (government job or business)

- Being able to afford proper housing

- Flashing to the village people once a year /j

- Ensuring a future for their kids and sometimes relatives/family