Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Text Default in Cell

  1. #1


    Hi 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!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    The Hague, NL
    Post Thanks / Like
    43 Post(s)
    8 Thread(s)


    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts