message box/question box in a formula

  • Thread starter Thread starter test80
  • Start date Start date
T

test80

hi i really need some help

i need to create a formula or macro that looks at a cell and if i
contains summin (e.g. the text 're-order') it displays a message bo
that says do you want to blah blah blah with options yes or no , n
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 formul
and if not could this be done using a macro. it needs to be don
automaticly so whenever text enters that cell it needs to realis
straight away, not after manually clicking a macro button.

can anybody help? would be so greatfull!

have a gd sunday everybod
 
As before.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

test80 said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top