Text Default in Cell

Feb 21st, 2002, 10:28 AM

Hi guys....here is my question:

I have a created a model, and in a certain cell (B4), I would like the text "Enter Value Here" to appear in order to direct the user. However, the user will then add a number, and I would like the text to disappear. When the number is deleted, I would like the text to re-appear. In other words, instead of the cell defaulting to empty, I would like it to default to showing the text I have described. Any help would be great ....thanks!

Aladin Akyurek · Feb 21st, 2002, 10:36 AM

In B4 enter: =IF(LEN(C4),"","Enter Value Here")

C4 is of course the cell where you enter a value.

If you want the value to be entered in B4 itself, you'll need code in VBA.

I leave the latter to the VBA army around here.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 10:28 AM	#1
Guest Posts: n/a	Hi guys....here is my question: I have a created a model, and in a certain cell (B4), I would like the text "Enter Value Here" to appear in order to direct the user. However, the user will then add a number, and I would like the text to disappear. When the number is deleted, I would like the text to re-appear. In other words, instead of the cell defaulting to empty, I would like it to default to showing the text I have described. Any help would be great ....thanks!

Feb 21st, 2002, 10:36 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	In B4 enter: =IF(LEN(C4),"","Enter Value Here") C4 is of course the cell where you enter a value. If you want the value to be entered in B4 itself, you'll need code in VBA. I leave the latter to the VBA army around here.