Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
Can I set cells to default to CAPS only when text is entered?
Thanks, Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
Use the CAPS LOCK key
-- Gary''s Student "Mosaic Steve" wrote: Can I set cells to default to CAPS only when text is entered? Thanks, Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
Not the answer im looking for.. I need a default set so anyone who opens the
spreadsheet and enters data, the text will automatically default to caps. I can do this in VB and other programs. Not sure if Excel has that feature. "Gary''s Student" wrote: Use the CAPS LOCK key -- Gary''s Student "Mosaic Steve" wrote: Can I set cells to default to CAPS only when text is entered? Thanks, Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
Nothing built into excel, but you can use an event macro.
See Chip Pearson's site: http://cpearson.com/excel/case.htm You can read more about events at: Chip Pearson's site: http://www.cpearson.com/excel/events.htm David McRitchie's site: http://www.mvps.org/dmcritchie/excel/event.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mosaic Steve wrote: Not the answer im looking for.. I need a default set so anyone who opens the spreadsheet and enters data, the text will automatically default to caps. I can do this in VB and other programs. Not sure if Excel has that feature. "Gary''s Student" wrote: Use the CAPS LOCK key -- Gary''s Student "Mosaic Steve" wrote: Can I set cells to default to CAPS only when text is entered? Thanks, Steve -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
I understand. You can control CAPS LOCK. See:
http://groups.google.com/group/micro...b7257930476d1d Include a call in a workbook open event macro to set CAPS LOCK on. To learn about event macros. see: http://www.cpearson.com/excel/events.htm -- Gary's Student "Mosaic Steve" wrote: Not the answer im looking for.. I need a default set so anyone who opens the spreadsheet and enters data, the text will automatically default to caps. I can do this in VB and other programs. Not sure if Excel has that feature. "Gary''s Student" wrote: Use the CAPS LOCK key -- Gary''s Student "Mosaic Steve" wrote: Can I set cells to default to CAPS only when text is entered? Thanks, Steve |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Defaults
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column 8 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub Right-click on the sheet tab and "View Code" Copy/paste the code into that module. Operates on columns A through H. Change the Target.Column = 8 to adjust. Gord Dibben MS Excel MVP On Thu, 14 Sep 2006 06:00:02 -0700, Mosaic Steve wrote: Not the answer im looking for.. I need a default set so anyone who opens the spreadsheet and enters data, the text will automatically default to caps. I can do this in VB and other programs. Not sure if Excel has that feature. "Gary''s Student" wrote: Use the CAPS LOCK key -- Gary''s Student "Mosaic Steve" wrote: Can I set cells to default to CAPS only when text is entered? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |