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

Jan

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?

--
Rick (MVP - Excel)


"Jan Kronsell" wrote in message
...
Is it possible, using VBA ,to list alle worksheet functions in Excel?

Jan

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




"Jan Kronsell" wrote:

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

Jan

Also, in Excel help, type:

List of worksheet functions (by category)




"Jan Kronsell" wrote:

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

Jan

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

Rick Rothstein wrote:
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?

"Jan Kronsell" wrote in message
...
Is it possible, using VBA ,to list alle worksheet functions in Excel?

Jan

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

Jan

JLGWhiz wrote:
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




"Jan Kronsell" wrote:

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

Jan

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

Thanks.

Jan

egun wrote:
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