| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox = Capital letters ?
TextBox2.ControlSource = UCase(Value) ' not working
I get no error but i also get no Capitals. How to set the Textbox2 to be ALWAYS Capitals? Corey.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox = Capital letters ?
Thants where it is now but no workies:
Private Sub TextBox2_Change() TextBox2.ControlSource = UCase(Value) End Sub Corey.... "Tom Ogilvy" wrote in message ... Use the change event to make the entry uppercase. -- Regards, Tom Ogilvy "Corey" wrote: TextBox2.ControlSource = UCase(Value) ' not working I get no error but i also get no Capitals. How to set the Textbox2 to be ALWAYS Capitals? Corey.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox = Capital letters ?
Thanks Tom.
Spot on. "Tom Ogilvy" wrote in message ... textbox2.value = Ucase(Textbox2.Value) not controlsource and not value. -- Regards, Tom Ogilvy "Corey" wrote: Thants where it is now but no workies: Private Sub TextBox2_Change() TextBox2.ControlSource = UCase(Value) End Sub Corey.... "Tom Ogilvy" wrote in message ... Use the change event to make the entry uppercase. -- Regards, Tom Ogilvy "Corey" wrote: TextBox2.ControlSource = UCase(Value) ' not working I get no error but i also get no Capitals. How to set the Textbox2 to be ALWAYS Capitals? Corey.... |
| 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) | |||
| Capital Letters Only | Excel Discussion (Misc queries) | |||
| Capital Letters | Excel Programming | |||
| Capital Letters | Excel Worksheet Functions | |||
Linear Mode
