Hi, I am trying to write a macro that will have the list box look at a cell in another worksheet and based on that data, lookup the corresponding data in another worksheet which will be used as the data for the list box. Formula I am using for cells =if(isblank(WorkSheet!H11),"""",VLOOKUP(L10,'Cust data'!A2:AM30,28,FALSE)) which gives me the result I want in a cell, but I want the same thing to occur in a dropdown list box. Thx.
