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

Thread: Text Default in Cell

  1. #1
    Guest

    Default

    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!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,660
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default


    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
  •