Highlight all Text in a Textbox when the textbox is selected

[RPIJG]

I must be missing something, but when I select the text box I want all of the information in the text box selected automatically so that I can just start entering information and the original text is deleted. Please help.

[Tom Ogilvy]

What kind of text box. Where is it located? Are you asking how to program
something or just wishing?

--
Regards,
Tom Ogilvy



"RPIJG" <[email protected]> wrote in
message news:[email protected]...
>
> I must be missing something, but when I select the text box I want all
> of the information in the text box selected automatically so that I can
> just start entering information and the original text is deleted.
> Please help.
>
>
> --
> RPIJG
> ------------------------------------------------------------------------
> RPIJG's Profile:
http://www.excelforum.com/member.php...fo&userid=9285
> View this thread: http://www.excelforum.com/showthread...hreadid=480188
>

[Leith Ross]

Hello RPIJG,

If you want to highlight the text inside a TextBox on a user form when the user clicks the TextBox, this code will do that.

Inset this code into the Mouse_Up Event for the TextBox. Change TextBox1 in the Example to match the name of your TextBox.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[RPIJG]

Sorry Tom I guess it was a bit of both, a wish and a need to program, Leith that works great thanks.