In my opinion, people and places should be entered in Proper Case, not Upper
Case.

UPPER CASE IS DIFFICULT TO READ AND HARD ON THE EARS!


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 20:23:00 -0800, Sai Krishna
wrote:


Thanks, this was very useful. I just needed to make some slight adjustments
in the formula to get the worksheet working. Thanks.. very useful to enter
names of people, places etc. that should always be capital letters.

Thanks a ton once again

regards
sai



"Mike H" wrote:

You could right click the sheet tab, view code and paste this in. Change the
range to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:A")) Is Nothing Then
On Error Resume Next
Application.EnableEvents = False
If Not Target.HasFormula Then Target.Value =
UCase(Target.Value)
Application.EnableEvents = True
On Error GoTo 0
End If
End Sub

Mike

"Srikanth" wrote:

Hi All,

I've a query regarding attendance sheet in excel. If we key in lower case
letter it shud take it as upper case. ANY IDEAS????

Thanks in Advance...