Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change range in capital letters on load
Hi all
How can I change the range between B9 to B500 in capital letters. I would like to do it in a "on load" event, not using "=UPPER" because I dont wanna use adjacent column. Any help? Cheers Kelson |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change range in capital letters on load
Hi Kelson,
You need to install a macro, see http://www.mvps.org/dmcritchie/excel/proper.htm#upper Microsoft Word does have the feature builtin, but not Excel. To install the macro see http://www.mvps.org/dmcritchie/excel....htm#havemacro You would make your selection and then invoke the macro. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Kelson" How can I change the range between B9 to B500 in capital letters. I would like to do it in a "on load" event, not using "=UPPER" because I don't want to use adjacent columns. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change range in capital letters on load
Hi Kelson,
You can use a worksheet_change event macro to capitalize a cell within you range when the cell is changed. (constants). Probably have less overhead than changing ranges whether they need to be changed or not. You would fix all of the cells first time (once) with the uppercase example for a selection then this could maintain it. More on Event macros http://www.mvps.org/dmcritchie/excel/event.htm Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'to install -- right-click on the sheettab of the corresponding ' sheet and choose 'view code'. Paste the following procedure ' in the module. -- this is for worksheet Change EVENT macros ONLY. ' Capitalize B9:B500 upon manual change of a single cell in this range If Target.Column < 2 Then Exit Sub If Target.Column 500 Then Exit Sub On Error Resume Next 'insure that Enable Events gets reenabled Application.EnableEvents = False Target.Formula = UCase(Target.Formula) Application.EnableEvents = True 'MUST be reenabled with True On Error GoTo 0 'resume normal error handling End Sub -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "David McRitchie" wrote in message ... Hi Kelson, You need to install a macro, see http://www.mvps.org/dmcritchie/excel/proper.htm#upper Microsoft Word does have the feature builtin, but not Excel. To install the macro see http://www.mvps.org/dmcritchie/excel....htm#havemacro You would make your selection and then invoke the macro. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Kelson" How can I change the range between B9 to B500 in capital letters. I would like to do it in a "on load" event, not using "=UPPER" because I don't want to use adjacent columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
how do i turn all letters into capital letters? | Excel Discussion (Misc queries) | |||
how to change existing column to capital letters | Excel Discussion (Misc queries) | |||
How do I change a column of cells to all capital letters? | Excel Worksheet Functions | |||
Auto change font to 'capital letters' | Excel Worksheet Functions |