Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel format
Is there a way that when a user types text in a cell (col A) that if they
type it in small letters it will automatically format to all caps? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel format
Pam
No format available. You would have to use event code in VBA. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column <1 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub As written, operates on Column A as you enter text in any cell in Column A Change the 1 to whatever you wish. This is event code and must go into the sheet module. Right-click on the sheet tab and "View Code". Copy and paste the above into that module. Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 09:36:01 -0700, Pam Coleman wrote: Is there a way that when a user types text in a cell (col A) that if they type it in small letters it will automatically format to all caps? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel format
you can convert existing data to uppercase using =upper() to do it on the fly you'd need to apply a macro as above -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=563380 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |