application object - vba functions

[lezawang]

Hi

I have been under impression that to call any vba function (please see the list below), I need to use this syntax

application.FunctionName

but I just noticed that I can call these function without Application.

Sub myfunctions()
MsgBox Chr(66)
MsgBox Now()
MsgBox Int(55.12345)
End Sub

Is it safe to say I can call all the functions below without Application.FunctionName? Just the function name as above? and to call WorksheetFunction then I need to do

Application.Worksheetfunction.FunctionName

Thank you very much.

https://www.techonthenet.com/excel/formulas/index_vba.php

 

[RoryA]

You can call worksheetfunctions (most, but not all) using either Application.function or Application.WorksheetFunction.function. They mostly behave the same except in how they deal with errors. The Application.function version return an error value, whereas the worksheetfunction.function versions cause a run time error.

The functions you listed above are native VBA functions rather than Excel.

 

[lezawang]

Thank you very much for your help. Just to clarify, can I say that

1) to call VBA native functions - I just need to use function name (the list in the link above)

2) to call WorkSheetFunction functions I need to use this syntax Application.Worksheetfunction.FunctionName

With that I will be safe. But I do not have to use Application.FunctionName to call any WorkSHeetFunction
instead I will use Application.WorkSheetFunction.FunctionName

Thanks once again

 

[RoryA]

1. Correct.
2. No you can use either syntax in almost all cases. It just depends what you want to happen when there is an error.

 

[lezawang]

Thank you once again for the help. I see that I can call Sum for example using

Application.sum

Or

Worksheetfunction.sum

but if that is the case, when I say Application.sum, from Object oriented point of view, Application is a class/object and sum is a method/function in that class/object. So when I use Object browser, I should find an object called Application and inside it I should see Sum() but that is not the case. Why is that?

For WorksheetFunction, the object browser will list all its functions no problem. Thank you so much

Sub myfoo()
    Dim x As Integer
    Dim y As Integer
    x = Application.WorksheetFunction.Sum(Range("a1:a10"))
    y = Application.Sum(Range("a1:a10"))
    MsgBox x
    MsgBox y
End Sub

 

[RoryA]

For the reasons I mentioned here: https://www.mrexcel.com/forum/excel...-application-dot-post5270130.html#post5270130

 

[lezawang]

Ok got it. Thank you so much once again.

 

[RoryA]

Glad to help.