View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default 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....