I have used UDFs for a long time now, but in the last version of Excel (2016) I can't find a way to see the help text in the cell. The most I was able to do was to find the name I have assigned to the variables (but not the type of var) in the Insert Function Dialog Box. How can I show the type of variable, as in earlier versions?
The UDF I am using as an example is:
Public Function myMacro(oPt1 As Integer, oPt2 As Integer) As String
If oPt1 > 0 And oPt2 > 0 Then
myMacro = oPt1 * oPt2
Else
myMacro = oPt1 * oPt2 * -1
End If
End Function