How to add argument description to Macros/User Defined Functions in Excel VBA User-defined functions are created in Excel for helping the Excel users. It would be good to add descriptions of the arguments used in the functions. This can be done using Application.Macrooptions method Let us assume a small User Defined Function that takes an argument: Function A_Sample_UDF(ByVal sArg) MsgBox "Sample UDF " & sArg End Function The following code will add the UDF to information category Sub Add_UDF() Dim ArgDes As Variant ArgDes = Array("First Arg") Application.MacroOptions Macro:="Personal.XLSB!A_Sample_UDF", Description:="Sample Function", Category:="Information", ArgumentDescriptions:=ArgDes End Sub
Awaz Apni Baat Apni is started in new Vision of Pakistan, We want to see a real image of Pakistan in public Point of View, Our Pakistan with New Vision.
