Using SetFocus to have the cursor located in a text box each time, what
is the code to have the default text highlighted ready for a new entry
without first having to block or delete the existing textbox contents?

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi,

Set the enterfield behaviuor:

..EnterFieldBehavior = fmEnterFieldBehaviorSelectAll

Then use SetFocus to set the focus to it.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Using SetFocus to have the cursor located in a text box
each time, what
is the code to have the default text highlighted ready
for a new entry
without first having to block or delete the existing
textbox contents?

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.