| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
When I use TxtName.Activate (where TxtName is a textbox with some
narrative already in it) I'd like all the text to be selected, rather than the cursor just ending up at the end of the narrative. Any help greatly appreciated Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
Jason,
Use the SelStart and SelLength properties. E.g, With Me.TextBox1 .SelStart =0 .SelLength = Len(.Text) .SetFocus End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jason" wrote in message om... When I use TxtName.Activate (where TxtName is a textbox with some narrative already in it) I'd like all the text to be selected, rather than the cursor just ending up at the end of the narrative. Any help greatly appreciated Jason |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
Hi Jason,
TextBox1.SelStart = 0 TextBox1.SelLength = Len(TextBox1.Text) -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "jason" wrote in message om... When I use TxtName.Activate (where TxtName is a textbox with some narrative already in it) I'd like all the text to be selected, rather than the cursor just ending up at the end of the narrative. Any help greatly appreciated Jason |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
THANKS FOLKS - KNEW IT WOULD BE A QUICK ONE FOR SOMEONE
JASON "Chip Pearson" wrote in message ... Jason, Use the SelStart and SelLength properties. E.g, With Me.TextBox1 .SelStart =0 .SelLength = Len(.Text) .SetFocus End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jason" wrote in message om... When I use TxtName.Activate (where TxtName is a textbox with some narrative already in it) I'd like all the text to be selected, rather than the cursor just ending up at the end of the narrative. Any help greatly appreciated Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Head to head | Excel Discussion (Misc queries) | |||
| Testing someones skillz... | Excel Worksheet Functions | |||
| How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
| How do I find someones age in whole numbers? | Excel Discussion (Misc queries) | |||
| using 'enter' on a textbox to activate a command button? | Excel Programming | |||
Linear Mode
