View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Auto-Format Capitalizing

It is surely not. You can do it with VBA though. Put this in the worksheet
module:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
For Each cel In Target
If cel.Column = 2 Then
If cel.Formula < UCase$(cel.Formula) Then _
cel.Formula = UCase$(cel.Formula)
End If
Next
End Sub

HTH. Best wishes Harald

"Meesheltx" skrev i melding
...
I want one column in my spreadsheet to ALWAYS be capitalized. Surely

there
is a simple way to do this. Does anyone know of one?