speech recognition

[cjaynes]

Hi,
I'm using MS Office 2003, and I've just started using Speech Recog.
since I've injured a hand. In Excel, I'm trying to address two issues:
I want Excel to capitalize the first letter of every word (proper), but
I haven't found good instructions on how to apply that to the entire
worksheet. Also, I need to use the word "microphone" quite a bit, which
of course, turns off the micropone. I haven't yet found out how to
disable that function, or how to create a substitute word to use
instead. For example, I'd be glad to say 'mphone' and have Excel type
'microphone', but I haven't found that option yet.

Thanks in advance!
chet

 

[Dave O]

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

 

[David McRitchie]

You may regret having asked two completely different questions in the
same post, can't help you with speech recognition.

As far as proper case goes see my page
http://www.mvps.org/dmcritchie/excel/proper.htm

You can use a worksheet function -- not recommended unless you want
to always see the original and a changed version.

You can correct everything at once, whether it is a cell, group of cells,
a column, the entire page (ctrl+A)

You can use an Event macro to correct the entries as soon as entered

I would suggest the second method because you can customize which words
might need special attention McRitchie, IBM, Tale of Two Cities

 

[David McRitchie]

Misread the second part thought you were asking about Speech Recognition.
Another possibility besides that supplied by Dave O., would be to use
Tools, Autocorrect and add mphone to be changed to microphone