Sentence Capitalizatio
this may do what you want
Sub test()
With Range("A1")
.Value = LCase(.Value)
.Value = UCase(Left(.Value, 1)) & Mid(.Value, 2, Len(.Value))
End With
End Sub
--
Gary
"Minitman" wrote in message
...
Greetings,
How Do I use "Application.AutoCorrect.CorrectSentenceCap". I can't
seem to get it to work!
Or is there a different way to get the contents of a TextBox to
convert to correct sentence structure with the first letter of each
sentence to be capitalized and the rest lower case?
Any help will be appreciated.
-Minitman
|