Empty a textbox when selecting it

[pjardino]

Hello everybody.
I have this userform with two textboxes.
I've added this code so that the user nows what to enter:
If TextBox1.Value = Empty Then TextBox1 = "dd-mm-yyyy"
Also I've added this code Cancelbtn.SetFocus so that the textbox is not selected when you load the form.

My first question is when you select that textbox, regardless where the mouse clicks, the text disappears and you can enter your text.

Also when you're entering the date after you've entered de dd the "-" comes up automatically and the after the mm it does the same thing.

Many thanks,

Pedro

[BigBas]

This code will clear the textbox as soon as you click in it:

Please Login or Register  to view this content.

As far as modifying the entry into a date format, there is no "simple" way of doing it. You actually have to write code to make the change. For example:

Please Login or Register  to view this content.

Obviously, you will have to modify that code based on your format. Also, there should be checks to make sure that the number entered is in fact a number, and maybe error handling in case someone enters in a different amount of numbers (ie, 012207 = 01/22/07 vs 12207 = 1/22/07