Delete text from text box

[dpaton05]

I have a text box on my spreadsheet with some text in it, "Please type notes here", and when I click in it, I want the text to disappear. Is there a way to do this?

 

[dpaton05]

I just had an idea. A standard textbox works but I need it to delete the contents if it contains the phrase "Please type notes here", but if it doesn't, not to delete the contents as it may have been previously typed over. I can assign a macro to the text box but I don't know the code that would achieve this. Could someone help me please?

 

[DanteAmor]

It must be with an ActiveX Control textbox

Try this

Private Sub TextBox1_GotFocus()
  If TextBox1 = "Please type notes here" Then
    TextBox1 = ""
  End If
End Sub


Private Sub TextBox1_LostFocus()
  If TextBox1 = "" Then
    TextBox1 = "Please type notes here"
  End If
End Sub

Additionally in the Value property of the Textbox put this: "Please type notes here"

 

[dpaton05]

I tried using an active x text box but I need it to auto expand down with more text and I couldn't get it to do that.

 

[DanteAmor]

I tried using an active x text box but I need it to auto expand down with more text and I couldn't get it to do that.

How to expand?
Do you want to use a Listbox or a combobox?


Or do you want to put more lines in a single textbox?

Change EnterKeyBehavior property to True

Change Multiline property to True

 

[dpaton05]

I tried a text box with those settings but it won't get any larger as more lines are added. The text is just pushed up out of view the more times you hit enter. I need it to expand so all text is visible.

 

[DanteAmor]

I tried a text box with those settings but it won't get any larger as more lines are added. The text is just pushed up out of view the more times you hit enter. I need it to expand so all text is visible.

But that is another thread.
The main thread was to erase the text. What I sent you worked. I would like you to comment on this thread.


With pleasure I follow other threads, but you should close the first thread.

Change Autosize property to True

 

[dpaton05]

Sorry about that Dante, I will try and ask everything in the original post for a thread in future.

 

[dpaton05]

By the way, thank you for your answers above.

 

[dpaton05]

How do you close a thread?