Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi John
Regrettably not. You could do it though with some event code on your sheet Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Columns("A:E") If Not Intersect(Target, rng) Is Nothing Then Application.EnableEvents = False Target.Value = UCase(Target.Value) Application.EnableEvents = True End If End Sub In this example, columns A to E inclusive will have their values cahnged to upper case. You could make rng a single column, or, no contiguous columns such as ("A", "D", "G") To use Copy code above. Right click on your sheet tabView code Paste code into white pane that appears Alt+F11 to return to Excel Regards Roger Govier John Cutler wrote: Is it possible to pre-format a column of cells as "text" such that any entered text will automatically be converted to UPPER CASE? For example, entering lower "x" will be 'forced' by the formatting to automatically appear as cap "X". This would be comparable to database software that I use wherein I can assign a "field input mask" to a data entry field that "forces" all text entries to UPPER CASE. Thanks, John |
#2
![]() |
|||
|
|||
![]() Quote:
Have a good day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Upper Case Formula for Multiple Cells | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
Conditional Formatting based on Upper case | Excel Worksheet Functions | |||
Formatting Upper Case letters | Excel Worksheet Functions |