Format a cell with Capital/Small/Proper

[SMILE]

Hi
Can someone help me to format a cell with proper function. This is to be used in a cell to enter names and it has to covert the text automatically into "proper" function.
Eg. if I enter in A1, "james lee" it should automatically change to James Lee.
Thanks

[tom1977]

Hi try use such event code

Please Login or Register  to view this content.

[romperstomper]

I would recommend you turn off events:

Please Login or Register  to view this content.

[SMILE]

Hi romperstomper
Thanks your code is working but it is applicable for the entire sheet.
But I wanted to use this code only for Cell C5,C6 and C7
Also I have to use a different code for C8.
When I enter a value in C8, i wanted to run a macro (Application.Run "Edit_A")
Can you combine all these
Thanks

[romperstomper]

Perhaps simply:

Please Login or Register  to view this content.

[SMILE]

Thanks a lot romperstomper.... Give u star

[Cutter]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save