I have attached my work so far but have got to a point where I am not sure what I want to do is possible.
In the frame 'CL Criteria' the user will select the material, modality, form & design for both the right and left CL.
When they then click on 'Search' , is it possible for VBA to filter the list of CL's on the 'CL Data' worksheet for the Right Lens criteria and populate the 'Lens Choice' combobox with the results (name only), and to then repeat with the Left Lens criteria?
I would then need the original list on 'CL Data' to be cleared of filters.
Update: Solved it myself. Thanks to those who looked.
Bookmarks