I have an excel spreadsheet I am trying to build (Normally I work with Access/VBA).
On my main page I have an ActiveX combo box whose source is a list that is placename and number.
I've figured out how to display the placenames in the combo box and reflect the # in a cell.
I have a list on a 2nd page that contains various details and a placename number that matches the data above.
On my main page I have ?? cell imbedded combobox using data validation using the above list as a source.
What I would like to do is filter that list/source based on the number selected in the activex combobox.
Can I do this w/o adding a module?
If not, how do I do this :)