Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

vba excel register udf not working

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
 
Replies continue below

Recommended for you

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

Part and Inventory Search

Sponsor