WorksheetFunction.Proper (Excel)

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

Proper (Arg1)

Arg1: Text - text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text that you want to partially capitalize.

Dim strArg1 As String: strArg1 = 
Dim strProper As String
strProper = WorksheetFunction.Proper(Arg1:=strArg1)