Function String Words Class

ProperCaseInPlace

Convert the argument rValue to its proper-case equivalent and also return the value. The first character of each alphabetic word is converted to its upper-case equivalent and the remaining alphabetic characters are converted to their lower-case equivalent.

Signature (Visual Basic / VBA)

Public Function ProperCaseInPlace( _
    ByRef rValue As Variant _
    ) As Variant

Code Example

    Assuming
       Dim S As String
       S = "This is a TEST."
    for example
       ProperCaseInPlace(S) = "This Is A Test."
    leaves
       S = "This Is A Test."

Parameters

Parameter Description
rValue String containing the phrase which is to be converted to its proper-case equivalent.

Notes & Version History

Note Function uses the built-in character classification routines to determine which characters are upper-case and lower-case.