showing parameters on custom built functions

Quick question... can you write a function to show what parameters are required when the user calls the function from excel as it foes with the pre-built excel functions??

i.e. when you type =gearingRatio in excel it comes up showing it needs the 2 following parameters...

Function gearingRatio(longTermLiabilities, equityShareholdersFunds)
gearingRatio = longTermLiabilities / equityShareholdersFunds
End Function

Hello justin4480,

It would be nice if Excel did provide the Intellisense capability for UDFs, but unfortunately it doesn't. I don't even know of any advanced methods using COM or API to provide a workaround. So to the best of my knowledge, you can't add this feature yourself.

Sincerly,
Leith Ross