View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Help With TextBox Formatting

Hi Minitman,

Try:

Private Sub TextBox1_Change()
Me.TextBox1.Text = Application.Proper(Me.TextBox1.Text)
End Sub


---
Regards,
Norman



"Minitman" wrote in message
...
Greetings,

I would like to format Textbox1 on UserForm1 with the PROPER format
but I can't find any examples of how this is done.

Can anyone show me how?

TIA

-Minitman