| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform text box formatting
Is it possible to force Proper Case for any text typed into a User Form text
box? Thanks. -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform text box formatting
No. But you can change it whenever you want--when the user leaves the textbox
(Textbox1_AfterUpdate???) Jock wrote: Is it possible to force Proper Case for any text typed into a User Form text box? Thanks. -- Traa Dy Liooar Jock -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform text box formatting
As long as your TextBox will not contain too much text (things might get
sluggish otherwise), you can probably use this KeyUp event code to do what you want... Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, _ ByVal Shift As Integer) Dim Position As Long Position = TextBox1.SelStart TextBox1.Text = StrConv(TextBox1.Text, vbProperCase) TextBox1.SelStart = Position End Sub -- Rick (MVP - Excel) "Jock" wrote in message ... Is it possible to force Proper Case for any text typed into a User Form text box? Thanks. -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform Text Box Formatting | Excel Programming | |||
| Formatting UserForm Text Field as Numeric | Excel Programming | |||
| Formatting a Text Box on a UserForm | Excel Programming | |||
| UserForm text box Date formatting | Excel Programming | |||
| formatting text in TextBox in UserForm | Excel Programming | |||
Linear Mode
