VBA provides the UCase and LCase functions to convert text to upper and lower case, respectively. But what about proper case? For that, you’ll need to use the StrConv function.
StrConv(“my text here”, vbProperCase)
My Text Here
Alternatively, you can use the worksheet function PROPER, like this
Application.Proper(“more proper text”)
More Proper Text