Consulting

Results 1 to 3 of 3

Thread: Message in Every Cell

  1. #1
    VBAX Regular
    Joined
    Feb 2013
    Posts
    30
    Location

    Message in Every Cell

    Hi,
    I have downloaded an excel template from Microsoft (file attached). In it I have noticed a new thing which I tried to hard to find on net and tried to resolved myself but couldn't. Whenever you select a cell it give you a message what is the purpose of this cell. I actually want to use this feature in my another worksheet. Like if I select Cell D10 it gives a message "Automatically calculate percent weight loss". Same it the case with other cells.
    I look for a help that how could I use this feature in my other excel files.

    Regards
    Attached Files Attached Files

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    The guy is using Data Validation (Data>Data Tools>Data Validation) with a type of ANY (that is, not restricting the input), and an input message. I frequently use this technique, but with validation on the cell as well, such as a pick list, number bounds, etc.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Feb 2013
    Posts
    30
    Location
    Great, it worked, thanks a lot xld.

Posting Permissions

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