Hi all,
I want a drop down list on the first sheet of my workbook.
this should be populated with a list of vlaues in column A of another sheet (results of a query, so could increase in numbers)
I'm not sure whether to use a listbox or combobox.
(not sure of when to use one or when to use another)
I will be passing the value of this drop down into a query written in VBA.
can anybody advise.
possibily with the code that would be required to select a dynamic range in columnA of the other worksheet..
thanks in advance,
Matt
Bookmarks