Public Function ProperCaseInPlace( _
ByRef rValue As Variant _
) As Variant Assuming
Dim S As String
S = "This is a TEST."
for example
ProperCaseInPlace(S) = "This Is A Test."
leaves
S = "This Is A Test."See also: ProperCase Function
StrConv Function (Visual Basic 4+)rValue: String containing the phrase which is to be converted to its proper-case equivalent. Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.