macros and IF statements

Question

hi, i have 2 qns, hopefully simple enough for you to help me with. 1) i have 2 adjacent cells A and B. A is a validated list where it has 2 values. B should show something else that is dependent on A. my intention is to set this macro on a button and everytime the button is clicked, the 2 cells appear. 2) i have 4 cells- C, D, E. cells C, D, E are validated drop downs. when a value in C is selected, only the corresponding values appear in D, and E is dependent on the selection of C and D. i am very new to macro and aint very sure with excel scripting. hopefully i can get help from you.

thanks!

Answer 1

Your question is a little hard to follow. Let me ask a little bit about #1:

Do you want

x) To press a button, have inputs for A and B appear, choose a value for A and see the result of B, and press Accept or something?

or

y) Choose a value for A by validation drop-down box, then see the value for B and do something with it automatically?

or

z) something else?

(If we can clarify this, the question part #2 might make more sense. Thanks!)