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

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