As you type...............

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column 2 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Any cell you type into in columns A and B will be turned to UPPER case when
you hit ENTER

This is sheet event code.

Right-click on the sheet tab and "View Code". Copy/paste the code into that
module.

Edit the range to suit.


Gord Dibben MS Excel MVP

On Mon, 11 Aug 2008 04:38:01 -0700, shekhar
wrote:

i want to know that if in excel sheet we type in small letter and we want to
make that all in capital letter how to do that

regards,
shekhar