| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
uppercase
Range("A:A") Otto
"oldLearner57" wrote in message ... 10s! appreciated for the replied and it works!! how then I can change to have the effect for say, example, to the whole column? I tried changed the .Address to ' .Range = "A1:A1" ' but i got an error. can assist on this?? 10s again and 10s to community as well Wish all a Blessed Merry X'mas -- oldLearner57 "Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. 'The below code works on cell A1. modify to suit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Application.EnableEvents = False Target = UCase(Target) Application.EnableEvents = True End If End Sub -- Jacob "oldLearner57" wrote: hi community, how can i force a cell entry to have the text change to Uppercase? any guidance much appreciated 10s community :) -- oldLearner57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| uppercase | Excel Discussion (Misc queries) | |||
| Uppercase | Excel Discussion (Misc queries) | |||
| Uppercase help | Excel Discussion (Misc queries) | |||
| Uppercase help | Excel Discussion (Misc queries) | |||
| Uppercase | Excel Worksheet Functions | |||
![Otto Moehrbach[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
