vba excel register udf not working

[Coalhouse]

Hello. I am doing a udf. but I want the udf to provide some help, guidance on the arguments.
it does not work. i have excel 365.
Not that the addin works but I can not get the argument help to display appropriately. I tried everything. Pls help.



Sub RegisterUDF()
Application.MacroOptions Macro:="peAIR", _
Description:="calculate the PEair ", _
Category:="User Defined", _
ArgumentDescriptions:=Array( _
"PSbar: Pressure in bar", _
"DN: diameter in mm", _
"Gr: input 1 or 2, this is to select the colour ", _
"Fm: input 1 or 2. this is to select the type", _
"T: Temp")
End Sub

 

[MintJulep]

Take a look at this.

Register UDF with descriptions of arguments using excel addin

I have an addin with an UDF getRegExResult. I want to add a function description and arguments descriptions to this function, so when user installs the addin, closes, opens excel few times and goes...

stackoverflow.com

 

[Coalhouse]

Take a look at this.

Register UDF with descriptions of arguments using excel addin

I have an addin with an UDF getRegExResult. I want to add a function description and arguments descriptions to this function, so when user installs the addin, closes, opens excel few times and goes...

stackoverflow.com

Thanks

 

[Coalhouse]

did it work for you. It does not work for me. I tried everything. no luck.