Hi,

Wow, thanks for the quick responses to my question yesterday. Now I have
a new problem. When I reinstalled Excel after my hard disk crash, something
went wrong with the Help files. When I press F1 for help, a white window
pops up, like it's supposed to, but then it freezes. Doesn't go any further.
When I close it, another window pops up saying, `Program is not responding
....'

Sometimes I can get to help by highlighting a word and pressing F1, but
then the font in the window is twice as big as it used to be, and the file
doesn't seem complete. This is true of both Excel Help file and VBA help
files.

Right now, I'm specifically trying to find proper syntax for the
capitalize function. I thought this would work:

Worksheets(1).Cells(2, 2) = vbProperCase(Worksheets(1).Cells(2, 2)

but it doesn't.

Any idea what's going on??

Sam

Hi Sam,

don't know about help.

Sub Test5555()
Dim sTmp As String
sTmp = Worksheets(1).Cells(1, 1).Value
sTmp = StrConv(sTmp, vbProperCase)
Worksheets(1).Cells(1, 1).Value = sTmp
End Sub

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Be cdarefull with this one Helmut.

Will change any formulas to values.

This won't.....................

Sub Test5555()
Dim sTmp As String
sTmp = Worksheets(1).Cells(1, 1).Formula
sTmp = StrConv(sTmp, vbProperCase)
Worksheets(1).Cells(1, 1).Formula = sTmp
End Sub


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 22:38:39 +0200, Helmut Weber
wrote:

Hi Sam,

don't know about help.

Sub Test5555()
Dim sTmp As String
sTmp = Worksheets(1).Cells(1, 1).Value
sTmp = StrConv(sTmp, vbProperCase)
Worksheets(1).Cells(1, 1).Value = sTmp
End Sub

Hi Gord,

always learning.

Thank you.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Sam, sometimes when I don't get what I am looking for from the VBA or Excel
help files, I just go to Google and type in something like Proper Case VBA.
Here is one of the sites that came up for me.

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

A lot of times there is better information on the net than in the help files.

"Sam" wrote:

Hi,

Wow, thanks for the quick responses to my question yesterday. Now I have
a new problem. When I reinstalled Excel after my hard disk crash, something
went wrong with the Help files. When I press F1 for help, a white window
pops up, like it's supposed to, but then it freezes. Doesn't go any further.
When I close it, another window pops up saying, `Program is not responding
....'

Sometimes I can get to help by highlighting a word and pressing F1, but
then the font in the window is twice as big as it used to be, and the file
doesn't seem complete. This is true of both Excel Help file and VBA help
files.

Right now, I'm specifically trying to find proper syntax for the
capitalize function. I thought this would work:

Worksheets(1).Cells(2, 2) = vbProperCase(Worksheets(1).Cells(2, 2)

but it doesn't.

Any idea what's going on??

Sam