Prompt on selection of cell?

[Lynn Kurtz]

In the invoice template that is supplied with excel (Sales Invoice 1)
they have a feature I haven't figured out. If you select one of the
cells at the bottom, a text box pops up giving instructions for what
to do with that cell. It is much like a comment but it isn't a
comment. How are those instruction boxes created?

--Lynn

 

[Harald Staff]

Hi Lynn

That's Data validation. See Debra's page
http://www.contextures.com/xlDataVal04.html
on this.

HTH. Best wishes Harald

 

[Lynn Kurtz]

Hi Lynn

That's Data validation. See Debra's page
http://www.contextures.com/xlDataVal04.html
on this.

HTH. Best wishes Harald

Thanks for the quick reply Harald. Jeez, I should have posted sooner
instead of wasting all morning searching for help on "prompts",
"tips", "messages" etc.

--Lynn