Hi Myrna,

I think I was mixing this with another post that asked for proper case :-)

Bob


"Myrna Larson" wrote in message
...
Hi, BobL

He said capitals, from which I assume upper case, so it should be

.Value = UCase$(.Value)

But if he did mean proper case, it has to be

.Value = Application.Proper(.Value)


On Tue, 8 Mar 2005 23:12:23 -0000, "Bob Phillips"
wrote:

You don't. You could use event code

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
.Value = Proper(.Value)
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.