Query via Userform

[JKoo1]

I created a userform with comboboxes (three of them) - they're drop downs. I would like to query the main sheet (sheet1). I've been researching this forever and the only things I see are about adding to the sheet etc.

For example, one colum of the sheet is colors (C). One of the comboboxes has a list of colors, and so on. Once you make all three choices in the drop downs and click search (command buttom), the entire row is pulled and placed into a new sheet (I have the code for opening the new sheet). Obviously, each combo box would have to be linked to the correct column (C for combox one, etc.).

Can this be done at all? I would think this is one of the reasons userforms were created (to query and add data). If it can't be done let me know and I'll scrap this thing.

Thanks,

[tigeravatar]

JKoo1,

Yes this can be done. Using the Range.Autofilter method might be a good place to start.

[mehmetcik]

Ok
I have no idea what you are trying to acheive,

So I have created a userform that shows colors in comboboxes.

I know I can improve it to display the color palette and will do so now,

But in the meantime,

Enjoy

[mehmetcik]

Ok
This version throws up a color palette if you click on the top left.
Enjoy.