PROPER case in VBA

[A Merchant]

Excel has UPPER, LOWER and PROPER functions to convert the text to upper case, lower case or proper case. I know that VBA has UCase and LCase in place of UPPER and LOWER functions. Is there an equivalent in VBA for PROPER function?

 

[Richard Schollar]

Hi

You can use the WorksheetFunction.Proper:

Msgbox Application.Worksheetfunction.Proper("this will proper case this sentence")

 

[RoryA]

You can use:

Application.Proper("text here")

or:

strconv("text here", vbProperCase)

HTH

 

[A Merchant]

Thanks. That worked.