Hi,
I would like to create a list box in a form that lists all math functions of
Excel. Is there a way I can easily re-use the list that is displayed when you
use Insert / Function / Math ... ?

Thanks,

MrT

Is this the list you are looking for?

ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC


--
Rick (MVP - Excel)


"MrT" wrote in message
...
Hi,
I would like to create a list box in a form that lists all math functions
of
Excel. Is there a way I can easily re-use the list that is displayed when
you
use Insert / Function / Math ... ?

Thanks,

MrT

On Sat, 24 Jan 2009 13:32:25 -0500, "Rick Rothstein"
wrote:

Is this the list you are looking for?

ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC


Those are the methods/function in the "Math & Trig" category.
But the OP wanted the methods/function in the "Financial" category.
Is it possible to get the list programmatically out of the
WorksheetFunction object?

Lars-Åke