Data validation - interlink two list box

November 23, 2011 at 20:09:51
Specs: Windows XP
I actually can get the 1st row to work using INDIRECT function "1st and 2nd list". But when I try to drag the 1st row list down(or the initial list cell) then the 2nd column always refers to whatever the 1st list cell item is. I have to change the 1st list cell item for the 2nd list cell item to change in the following rows. To make all the rows work, not just the 1st row, Am i still using the indirect function? pL some one give some examples.... how to interlink the two list box...
thanks in advance

See More: Data validation - interlink two list box

November 24, 2011 at 05:16:09
I don't use list boxes, so I'm having a little trouble understanding what your problem is.

If you could explain what you are doing with actual examples and the steps you've taken, I'll do some testing and see what I can find out.

Before posting any data, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question