Quick question about format

[handbtys]

Hi,

I need a column of cells to ALWAYS be in ALL CAPS.

This means that if I go to any cell in that column and type normally, when I exit the cell, it will be capitalized.

Can anyone help?

 

[Jon von der Heyden]

Hi,

You could add this code to your worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
   If IsEmpty(Target) Then Exit Sub
   If Target.Cells.Count > 1 Then Exit Sub
   Application.EnableEvents = False
   Target.Value = UCase(Target.Value)
   Application.EnableEvents = True
End Sub

Regards,
Jon

 

[handbtys]

I needed some amendments so that it works for only a specific colum.

But many thanks... because I couldn't have done it without your help.