Hi Jodie,
Save that hair!
Here's a quick take on a form that may meet your needs. (It only identifies the requirements that you have specified).
Open up the spreadsheet, and press Alt+F11, to bring up the VBA environment. Doble-click on UserFOrm1 (on the left hand side, in the folder called forms), and press F5.
As you choose different combinations (4 of them) of manufacturers, you'll see the criteria that will be used to load the phone.
Note:
This model allows you to choose either or both or none, because you didn't indicate that the selection was mutually exclusive.
Let me know if this gives you any ideas (it is very simple code, and you should be able to understand it just be looking at it), and then get back to us!
HTH
Tony
Bookmarks