Try:

Private Sub TextBox1_MouseDown(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
TextBox1 = ""
End Sub

--

Vasant


"scottnshelly " wrote in
message ...
i gotta userform with some text boxes. the people that will be using
this userform are not computer literate. is it possible to put text in
the textbox like "type here" but make the text go away when it's
clicked? i've tried a few things like
textbox1.value = "type here"
private sub textbox1_click
textbox1.value = ""

no soup.
what else should i try?
thanks MVP's!


---
Message posted from http://www.ExcelForum.com/