lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
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