Input Dialog box

[NoviceExcelUser]

I am trying to create a dialog box in one cell which checks value in anoth
cell (e.g. yes or no) and if it is yes, then asks for a value number (1-100)
and if it is no 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

 

[ShaneDevenshire]

Hi,

What do you mean by dialog box? Dialog boxes don't appear in cells.

You could have a little text an adjacent cell which responds to something in
a given cell. You could have a userform (dialog box) pop up on screen with a
message, but that would require VBA programming, is that something you want
to learn for a little message? Alternatively you can have a comment in the
cell which has both instructions.

Keep in mind if the cell has "no" in it you want 0 in it. But if it has 0
in it you want a message telling the user to enter a number? A cell can have
only one thing in it at a time. When the user type no in they would wipe out
any formulas that were already there.