| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select (highlight) Text in txtBox at Initialization
Glad I could help and thanks for the feedback
"Hal" wrote: Thanks Mike, Worked as needed. "Mike H" wrote: Hi, Try this Private Sub UserForm_Initialize() With Me.TextBox1 .Value = "test" .SelStart = 0 .SelLength = Len(.Value) End With End Sub Mike "Hal" wrote: When tabing through the text boxes on my form all data within a text box is selcted because the EnterFieldBehavior is set to select all. On form initilization the first text box in the tab order has the cursor at the end of the field. I want to have all text in this box selected at form initalization. You advise is appreciated to fill in the line of code below, txtBoxName, Private Sub UserForm_Activate() txtBoxName (select all the text in the box) End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select / highlight entire row. | Excel Programming | |||
| highlight select data | Excel Discussion (Misc queries) | |||
| Highlight (ie Select characters in a textbox) | Excel Programming | |||
| why do 2 cells highlight when I only select 1? | Excel Discussion (Misc queries) | |||
| Highlight/Select text in User Form? | Excel Discussion (Misc queries) | |||
Threaded Mode
