It is an event macro which means that it responds automatically to input in
the referenced cells, which in this case was column A (1). So, anytime you
input something in col A, the macro will fire.

To see some other sheet event macroslook in the right window of the sheet
module.

--
Don Guillett
SalesAid Software

"Craig" wrote in message
...
Don,

followup..I got it to work...thanks...but why dont I have to run it as a
standard macro? how does it know to run after I press Enter in the
worksheet
cell.

thanks...great code

craig

"Don Guillett" wrote:

try right click sheet tabview codecopy paste thisSAVE. as written
works
only in col A (1)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
Application.EnableEvents = False

If Target.HasFormula Then
Target.Formula = Application.Proper(Target.Formula)
Else
Target.Value = StrConv(Target.Value, vbProperCase)
End If
Application.EnableEvents = True
End Sub

--
Don Guillett
SalesAid Software

"Craig" wrote in message
...
How do you get Excel to capitalize automatically the first letter when
typing
a name in each cell. Example, when I type a name, I have to manually
capitalize the first letter in the name.

Thank you very much