UserForm for filtering/querying a database of parts

Hi,

I am a newb at VBA and would like some help.
I am trying to create a UserForm that queries/filters data from a database of parts on sheet 1 ("Components") and copy relevant information to sheet 2 ("Rx Analysis") for analysis.
I have created comboboxes that relate to the relavent cells of sheet 1. Now I want to update the selection criteria of the other comboboxes based on the selection of the other comboboxes i.e. filtering the part selection.
I would also like the remaining database part to be placed into a listbox. Once a part has been selected the form fills in the correct values into the correct fields on sheet 2.
See attached .xlsm
Is there anyone who can help with this?

Regards,

MattParryReceiver, Transmitter, and DC Analysis V3.xlsm

Matt

What exactly do you want to happen with the comboboxes?

For example if I select Amplifier from the type combobox what should happen?

Hi Norie,

After selecting the part type="Amplifers" The Category combobox should only show components of type="Amplifers" and same for MPN combobox.