cutome text format?

[aazar]

How can I get Excel to display text in caps without having to use
formuli? There is no facility like work to set Font to Caps or small
caps or do a custom Text format or is there?

 

[Don Guillett]

right click sheet tab>view code>insert this. I have restricted to column 5
only so modify to suit.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 5 Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End Sub

 

[aazar]

I am very grateful for you assistance.

right click sheet tab>view code>insert this. I have restricted to column 5
only so modify to suit.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 5 Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End Sub

 

[Don Guillett]

Glad to help