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 |