| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting Textbox1 Value when form initializes.
I have a userform and would like on userform initialization to highlight the
text in textbox1. What would the code be for this? Thanx Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlighting Textbox1 Value when form initializes.
Todd,
Use code like the following: Private Sub UserForm_Initialize() With Me.TextBox1 .SelStart = 0 .SelLength = Len(.Text) End With End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... I have a userform and would like on userform initialization to highlight the text in textbox1. What would the code be for this? Thanx Todd Huttenstine |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlighting Textbox1 Value when form initializes.
thanx
"Chip Pearson" wrote in message ... Todd, Use code like the following: Private Sub UserForm_Initialize() With Me.TextBox1 .SelStart = 0 .SelLength = Len(.Text) End With End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... I have a userform and would like on userform initialization to highlight the text in textbox1. What would the code be for this? Thanx Todd Huttenstine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
| TextBox1 to Label4 | Excel Discussion (Misc queries) | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| UserForm1.Textbox1.SetFocus Question | Excel Programming | |||
![Todd Huttenstine[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
