List worksheetsheet functions

[Jan Kronsell]

Is it possible, using VBA ,to list alle worksheet functions in Excel?

Jan

 

[Rick Rothstein]

Can you clarify that a little? Do you mean list all the built-in Excel
functions that can be used in a formula? Or did you mean list the all the
functions that are present in a worksheet? Or did you actually mean list the
formulas that are used in the cells on a worksheet? Also, if not the first,
do you mean just for one sheet or for all sheets?

 

[JLGWhiz]

You can get a printable list of worksheet functions available to VBA by
typing the following into the VBA Help search box, then clicking on it in the
help options window.

List of Worksheet Functions Available to Visual Basic

 

[JLGWhiz]

Also, in Excel help, type:

List of worksheet functions (by category)

 

[Jan Kronsell]

What I like is a list of available built-in worksheet-functions, listed in a
column in a sheet, one function in each cell.
If possible it should also list UDF's from installed add-ins. Sometinh like
this

ABS
ADDRESS
VLOOKUP
HLOOKUP
MyFunction1
MyFunction2

and so on.

Jan

 

[Jan Kronsell]

I know that, but I need the list en a Worksheet.

Jan

 

[egun]

You can also look up the RegisteredFunctions property in VBA Help. This will
list any non-built in functions (like those from DLLs or add-ins like the
Analysis TookPak). Their example code:

Sub List_Registered_Functions()
theArray = Application.RegisteredFunctions
If IsNull(theArray) Then
MsgBox "No registered functions"
Else
For i = LBound(theArray) To UBound(theArray)
For j = 1 To 3
Worksheets("Sheet1").Cells(i, j). _
Formula = theArray(i, j)
Next j
Next i
End If
'
End Sub

HTH,

Eric

 

[Jan Kronsell]

Thanks.

Jan