Auto-Format Capitalizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting - highlight Capital letters but not lower c 2
text formating formulas 2
Capitals 3
Capitalization 7
Formula for formatting font/style 2
Changing all caps to proper 7
separate columns (three letter code) 7
Capitalise first word in a cell 2

Back
Top