Coalhouse
Mechanical
- Mar 15, 2012
- 29
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
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