Convert text in proper case in VBA

Use StrConv function to get your text in proper case.

For e.g. StrConv(”my text”, vbProperCase)

Will return
My Text

Alternatively, worksheet function PROPER can also be used...
For e.g. Application.WorksheetFunction.Proper("my text")

Will return
My Text