Thread: Show Cell Description

Hi all,

I am using excel 2000.

I am doing a form for user to fill in.

I want to add the description in a cell, so that user know what to fill in.
For example, when I have column with title 'e-mail', the cell that next to the title is for user to fill in. In that cell, I want to write 'Type your e-mail here'.
I wish this statement will disappear when user double click on it.

It some sort like Facebook, at the log-in column, there is a word 'e-mail' and when I click on that text box, the word 'e-mail' will disappear.

Is that possible at Excel 2000?

Thanks in advance.

With textboxes you could as it is event driven

Code:

Private Sub TextBox1_GotFocus()
    If TextBox1.Value = "Your e-mail here" Then TextBox1.Value = ""
End Sub

Private Sub TextBox1_LostFocus()
    If TextBox1.Value = "" Then TextBox1.Value = "Your e-mail here"
End Sub

Welcome to the Board.

Please ensure you post your questions in a relevant forum - thread moved from Tips & Tutorials to Excel General.

(p.s I hope the username is your own mailbox as it will invariably be inundated with Spam)