software

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 quot;microphonequot; 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--
cjaynes
------------------------------------------------------------------------
cjaynes's Profile: www.excelforum.com/member.php...oamp;userid=32362
View this thread: www.excelforum.com/showthread...hreadid=521196Hello, 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
(quot;Properquot; case), and couldn't do it. As an alternative, how would you
feel about running a macro? The macro that follows will change
quot;mphonequot; to quot;microphonequot; (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 quot;mphonequot; with quot;microphonequot;
Cells.Replace What:=quot;mphonequot;, Replacement:=quot;microphonequot;,
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 SubYou 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
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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;cjaynesquot; gt; wrote in message
...
gt;
gt; Hi,
gt; I'm using MS Office 2003, and I've just started using Speech Recog.
gt; since I've injured a hand. In Excel, I'm trying to address two issues:
gt; I want Excel to capitalize the first letter of every word (proper), but
gt; I haven't found good instructions on how to apply that to the entire
gt; worksheet. Also, I need to use the word quot;microphonequot; quite a bit, which
gt; of course, turns off the micropone. I haven't yet found out how to
gt; disable that function, or how to create a substitute word to use
gt; instead. For example, I'd be glad to say 'mphone' and have Excel type
gt; 'microphone', but I haven't found that option yet.
gt;
gt; Thanks in advance!
gt; chet
gt;
gt;
gt; --
gt; cjaynes
gt; ------------------------------------------------------------------------
gt; cjaynes's Profile: www.excelforum.com/member.php...oamp;userid=32362
gt; View this thread: www.excelforum.com/showthread...hreadid=521196
gt;
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