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.
Gizzle72
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.