I am trying to create a dialog box in one cell which checks value in another
cell (e.g. yes or no) and if it is true, then asks for a value number (1-100)
and if it is not then enters a zero. Can anybody help with this box, I am
novice use of excel so a step by step instructiion will be greatly
appreciated. Or you can refer me to a website or tutorial. Thanks