Make a cell PROPER automatically

[vietdieu]

Hi experts,
I have a thing that really needs your help. I want to make a text in a cell in PROPER case, for example, I enter a tex in a cell “make this proper”, after I finish by hitting Enter or Tab, the text in that cell will automatically proper the text to “Make This Proper”. I think this should have a macro but don’t know how to do it.
Thank for your help.

[DGagnon]

there is a formula that can help you

=PROPER(A1)

[vietdieu]

I knew how to Proper a cell, but here I want to proper the cell itself right after I edit it. Let's go back with my example, I modify Cell A1, as soon as I het Enter or tab to move to next cell, the text in A1 will be propered.

[nmhung49]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Application.Intersect(Target, Range("A1:O30")) Is Nothing Then
Target.Value = Application.Proper((Target.Value))
End If
End Sub 

[vietdieu]

I tried (I opened VBA, inserted module, copied the code, tried enter text to see if it change, Am I goingthe right way?) but seemed not work, can you please check it again, tkss!

[DGagnon]

instead of entering the code in a new module, double click you sheet in the browser on the left, and enter the code there.