Text Default in Cell
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Text Default in Cell

  1. #1


    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
    The Hague, NL
    Post Thanks / Like
    12 Post(s)
    1 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.

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