Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a popup window based on a cell value?
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 A18, 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a popup window based on a cell value?
Yes.
This is called Data Validation. See Excel Help -- Gary's Student "bumper338" wrote: 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 A18, 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a popup window based on a cell value?
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. "Gary''s Student" wrote: Yes. This is called Data Validation. See Excel Help -- Gary's Student "bumper338" wrote: 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 A18, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
How do I create a cell reference from a value within a cell? | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions |