Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Format Capitalizing
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto format quarter start date | Excel Discussion (Misc queries) | |||
how do i stop the auto format on excel? | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
auto date: cond. format Question | Excel Discussion (Misc queries) | |||
auto format chart colours | Excel Discussion (Misc queries) |