Data Validation List with IF in VBA?

[appu_gusai]

hello everyone,


please any one help me for Data Validation List working with IF Condition in VBA?

if Sheet1 A1=1, B1=1,2,3 (1,2,3 come from Sheet2) or A1=2, B1=A,B,C (A,B,C come from Sheet2) with ignore BLANK CELL

m need 13 different value in A1 n 13 Data Validation in B1 like above this

 

[Andrew Poulsom]

Look here:

Excel Data Validation -- Dependent Lists

 

[appu_gusai]

Look here:

Excel Data Validation -- Dependent Lists

thank's for this SIR

but i have lil more

A1=1, B1=1,2,3 (1,2,3 come from Sheet2) or A1=2, B1=A,B,C (A,B,C come from Sheet2) or A1=3, B1=X, C1=A?

 

[Andrew Poulsom]

In what way can't you use the technique in the link I posted?