How do I create a popup window based on a cell value?

[Guest]

I am new to this area, and I can not seem to find what I am looking for. I
am a big user of excel but I want to improve my knowledge and improve
somewhat manual proccess for which I use excel for.

What I would like to know is if there is a way to create a popup window when
a value in a cell or range of cells is greater than X. For example, if cell
A1>8, then I want a popup to have the user select option a or option b, is
this possible and if so how do I go about doing this?

Thanks for any assistance from you experts

 

[Guest]

Yes.

This is called Data Validation. See Excel Help

 

[Guest]

Thanks for the info, but this is not exactly what I am looking for.

What I am looking for is a way to give the person entering data a message to
select either option A or option B. If data validation will do this, then I
guess I am not understanding the Help Files.