Hi everybody,
I have a help to ask of you all. I am relatively new to vba and I have a doubt. I want to display different sets of values in my dropbox Ans 1 and Ans 2 depending on my selection in Var1 and var 2.
I tried writing an if loop in the macro for the dropbox Ans 1. but I am not sure how to refer back to it telling if my condition is satisfied do the following statement. hence i have included a dummy workfile for your reference so that you can see it and help me.

dummy.xlsm

For example in the attached sheet,

If I select var 1 = A and var 2= 2, then my ans 1 should display the cells c11:c17 and ans 2 would display d11:d17 or var 1 = A and var 2= 1 then it displays c3:c9 and d3:d9


It would be great if someone can help me with this if code. because once I have a structure i can build on it for my workfile. Looking forward to your help.

thanks again.