Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto caps lock
hi,
how to set outo caps loc (beside turn on caps lock button) at sepcifiy cell. if any latter enter into cell , he will change to caps lock . rgds ramzi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto caps lock
hi, ramzi !
how to set outo caps loc (beside turn on caps lock button) at sepcifiy cell. if any latter enter into cell, he will change to caps lock. if available, try to change the font for your range/worksheet/workbook/style/... (no other tricks/code/stuff/... needed) this fonts shows text un uppercase: - Castellar - Engravers MT - Felix Titling - Stencil - Technic (*versalles* type) this font shows text in lowercase: - Freshbot - Poornut - Pussycat hth, hector. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto caps lock
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Const WS_RANGE As String = "A1:A10" 'edit to suit On Error GoTo ErrHandler Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then Target.Formula = UCase(Target.Formula) End If ErrHandler: Application.EnableEvents = True End Sub This is sheet event code. Right-click on the sheet tab and "View Code". Copy/paste the above into the sheet module. Edot the range if need then Alt + q to return to the Exel window. Gord Dibben MS Excel MVP On Fri, 25 Jul 2008 00:05:01 -0700, ramzi wrote: hi, how to set outo caps loc (beside turn on caps lock button) at sepcifiy cell. if any latter enter into cell , he will change to caps lock . rgds ramzi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to disable the CAPS LOCK key ? | Excel Discussion (Misc queries) | |||
How do I set caps lock as default? | Excel Worksheet Functions | |||
Caps Lock and excel help | Setting up and Configuration of Excel | |||
forcing caps lock | Excel Worksheet Functions | |||
Reverse Caps Lock | Excel Discussion (Misc queries) |