View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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