Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box/question box in a formula
hi i really need some help i need to create a formula or macro that looks at a cell and if it contains summin (e.g. the text 're-order') it displays a message box that says do you want to blah blah blah with options yes or no , no doing nothing yes linking to a macro/or another sheet etc. I can't find how to do this. can you have a message box in a formula and if not could this be done using a macro. it needs to be done automaticly so whenever text enters that cell it needs to realise straight away, not after manually clicking a macro button. can anybody help? would be so greatfull! have a gd sunday everybody ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box/question box in a formula
See response in .misc. If you want to hit more than one NG, post to all at
once, please don't multi-post. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "test80" wrote in message ... hi i really need some help i need to create a formula or macro that looks at a cell and if it contains summin (e.g. the text 're-order') it displays a message box that says do you want to blah blah blah with options yes or no , no doing nothing yes linking to a macro/or another sheet etc. I can't find how to do this. can you have a message box in a formula and if not could this be done using a macro. it needs to be done automaticly so whenever text enters that cell it needs to realise straight away, not after manually clicking a macro button. can anybody help? would be so greatfull! have a gd sunday everybody ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get error message when I try to post a question | Excel Discussion (Misc queries) | |||
Message box question | Excel Discussion (Misc queries) | |||
Message Box - Quick Question | Excel Discussion (Misc queries) | |||
Simple message box question | Excel Discussion (Misc queries) | |||
Simple message box question | Excel Discussion (Misc queries) |