kirbz
10-11-2011, 03:05 AM
Need help in coding to have a condition in using a drop down list..
what I wanted to do is create a drop down list but the value of the drop down list will depend on the value of another cell..
for example if the value of Cell W1 = "PC" the value of the cell with the drop down list will contain "CTN and BOX" which is Y1.. but if the value of W1 = "BDL" the value of Y1 will contain "ROLL and GNY"...
and in addition.. the change of contents of Y1 will occur when I have selected Cell Y1..
is it possible and how to code it in VBA?
Thanks. hop you understand what I mean...
what I wanted to do is create a drop down list but the value of the drop down list will depend on the value of another cell..
for example if the value of Cell W1 = "PC" the value of the cell with the drop down list will contain "CTN and BOX" which is Y1.. but if the value of W1 = "BDL" the value of Y1 will contain "ROLL and GNY"...
and in addition.. the change of contents of Y1 will occur when I have selected Cell Y1..
is it possible and how to code it in VBA?
Thanks. hop you understand what I mean...