ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get an automatic reminder with a certain cell value? (https://www.excelbanter.com/excel-discussion-misc-queries/17584-how-do-i-get-automatic-reminder-certain-cell-value.html)

Aubri

How do I get an automatic reminder with a certain cell value?
 
Is there a way to receive a pop-up comment or text box when a certain thing
is typed into a cell? For example, each time I type "new instrument", I want
a reminder to pop-up like a comment would that says "Call Property
Accounting". Is there a function like this in Excel?

Dave Peterson

If you have a list of terms, maybe you can use an adjacent helper cell and use a
nice =vlookup() formula to show your message.

Debra Dalgleish has some instructions at:
http://www.contextures.com/xlFunctions02.html

Aubri wrote:

Is there a way to receive a pop-up comment or text box when a certain thing
is typed into a cell? For example, each time I type "new instrument", I want
a reminder to pop-up like a comment would that says "Call Property
Accounting". Is there a function like this in Excel?


--

Dave Peterson


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com