excel functions to VBA functions

[friel300]

i have come across a couple of times instances where there is a VBA function that does the same job as a function in excel

like
ASC
does tthe same as CHAR but it does it in VBA before going on to the sheet
my Question is
is there a way to get a list of ALL of the functions like this that exist in VBA???

 

[njimack]

Go to VBA help and search for "List of Worksheet Functions Available to Visual Basic"

 

[friel300]

also posted here

 

[friel300]

hmm thats good but they seem to only work in excel not vba
is there a way to do this without actually writing anything on the sheet??

and also the example wasnt there so this meens that there will be others that will not be there aswell.

any other places that i could look?

 

[friel300]

Use the Object Browser and type in worksheetfunction

you need to type

worksheetfunction.

before using one

solution found here