ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help With TextBox Formatting (https://www.excelbanter.com/excel-programming/315744-help-textbox-formatting.html)

Minitman[_4_]

Help With TextBox Formatting
 
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

Norman Jones

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





All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com