I need code to activate autofilter allowing the user to select criteria from a specific Field. I'd hoped to simply activate the autofilter and pause execution while the user selected the appropriate criteria and then processing would continue.
The sole reply to my prior post suggested populating a list of the field's criteria in an Inputbox. If this is the only solution could someone supply me with some code showing how to amass the criteria examples and then populate a list in an Input Box?
Any help will be most appreciated.
Thanks in advance.
Ted
The sole reply to my prior post suggested populating a list of the field's criteria in an Inputbox. If this is the only solution could someone supply me with some code showing how to amass the criteria examples and then populate a list in an Input Box?
Any help will be most appreciated.
Thanks in advance.
Ted