TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD

[jason]

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

 

[Chip Pearson]

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

 

[Rob Bovey]

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]

THANKS FOLKS - KNEW IT WOULD BE A QUICK ONE FOR SOMEONE

JASON