vba functions are not under application.(dot)

[lezawang]

Hi
I wanted to use Trim function (Application.Trim) in my code. So I went to Object Browser and typed Application, thinking that under Application, I will see these functions. Otherwise why it is (Application.trim). But to my surprised, I could not find Trim or other functions under Application!! So I typed Trim and found out Trim is member of Strings Class and String is under VBA

So it is VBA.Strings.Trim

So my question, why people say Application.Trim? and it does work application.trim?

Thank you very much

 

[Fluff]

Trim is a WorksheetFunction, so it should be

Application.worksheetfunction.trim

although you can missout either the Application, or the worksheetfunction & it will work

 

[RoryA]

There is also a native VBA Trim function which doesn't behave quite the same way as the Worksheetfunction version. (It doesn't trim multiple spaces within a word)

 

[lezawang]

Thank you all. I wrote the following code and only line 2, did the job correctly
but I still not sure why I can not find Trim function under Application, using object browser
Thank you

Sub myvba_function()
    MsgBox VBA.Strings.Trim("     hello            there")
    MsgBox Application.Trim("     hello            there")
    MsgBox Trim("     hello            there")
End Sub

 

[RoryA]

The first and third are the same function.

The functions under Application are deprecated, which is why you can't see them. They are also late bound, hence no intellisense.