Using Proper case with Brackets/Parentheses

[moogthemoog]

Hi

I'm using Change Event code to convert strings to Proper Case (using vbProperCase), which works fine changing "client name" to "Client Name".
However, where there is a string such as "client name (location)", it just converts to "Client Name (location)" - i.e. it doesn't change the first letter after the parenthesis.

Putting a space between the "(" and "l" does make capitalise the "L", but the layout doesn't look right with a space.

Even if the "(Location)" already uses a capital L, the code changes it to lower case.

Is there another code to use instead of vbProperCase?

Code used is:

If IsNumeric(Target.Value) = False Then _
Target = StrConv(Target.Text, vbProperCase)

Many thanks,
Jon

 

[Sandeep Warrier]

How about

WorksheetFunction.Proper(Target.Text)

 

[moogthemoog]

Brilliant, that works beautifully!

Thank you.