View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default speech recognition

Hello, Chet-
I was trying to find a way to format or otherwise rig a cell to enter
any text input with the first letter of every word capitalized
("Proper" case), and couldn't do it. As an alternative, how would you
feel about running a macro? The macro that follows will change
"mphone" to "microphone" (you can change that if you need to) and then
converts all text to Proper case.

You'd need to run this macro after every input session. Depending on
how you feel about that sort of thing, we could arrange to run the
macro every time a cell is changed or updated. Let us know what you
think.

Sub All_Caps()
Dim rCell As Range

'replace "mphone" with "microphone"
Cells.Replace What:="mphone", Replacement:="microphone",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

'convert all to proper case
For Each rCell In ActiveSheet.UsedRange
rCell.Value = StrConv(rCell.Value, vbProperCase)
Next rCell
End Sub