Ah yes, I have seen the light. Much better. Thank you.
Sincerely,
MonkeyPaws
CEO, MonkeyPawsRUs, Inc.
Quote:
>-----Original Message-----
>Hi MonkeyPaws
>Can you change the string first and then insert it, as in
the following?
>strReturnValue = "This is a string THAT HAS several words
in it"
>strReturnValue = StrConv(strReturnValue, vbProperCase)
>MsgBox strReturnValue
>HTH
message
>> If Trim(strReturnValue) <> "" Then
>> With Selection
>> .InsertAfter strReturnValue
>> .Range.Case = wdTitleWord
>> .Collapse wdCollapseEnd
>> End With
>> End If
>> It would appear this would make the string title case
but
>> it does not. The return value string typically has
values
>> of "This is a string THAT HAS several words in it."
>> The "THAT HAS" part of the string does not become Title
>> Case. It remains all caps. However, the remainder of the
>> string (lower case) is changed to Title Case. Any ideas
>> are appreciated.
>> Sincerely,
>> MonkeyPaws
>> CEO, MonkeyPawsRUs, Inc.
>.