MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple Column List Box

Posted by jwolk on May 28, 2000 7:15 PM

I am using MS Query to import 2 columns from an Access table into Excel and would like to be able to incorporate the columns in a validation list box consisting of the two columns. I want the user to be able to choose any value in column A and have the associated adjacent cell in column B to follow the choice in A. Can someone help me on this? I just found this board. Thanks. Jim

Posted by jwolk on June 03, 2000 12:22 AM

I wrote an Access macro to create a table of the 2 needed columns, copy the columns, open excel, paste special as csv, auto filter the columns, and control the filtered list with an excel macro attached to a show all button. I guess this one was either too hard or too easy. thanks