User Form Text Box - auto delete prompt text

[porky2j]

Hi Guys,

I have a text box that I am using to record date of birth. I am using
the DD/MMM/YY format to avoid US / UK format confusion. I have written
the text 'DD/MMM/YY' in the text box as a prompt for the user to enter
the correct date format.

At the moment when the user clicks the Date of Birth text box they
either need to delete the 'DD/MMM/YY' text or press insert to
overwrite it. Is it possible to get this text to automatically delete
once the text box is clicked?

I have searched the group but can't find anything - any help would be
great!!

Thanks in advance

Paul

 

[Susan]

Private Sub Textbox1_Click()
Textbox1.value = ""
End Sub

hope that helps!
susan

 

[Susan]

ignore that - there apparently is NO click event for a
textbox.........
hmmmmmm.
i don't know!
sorry
susan