Userform with Multiple Searches

[busbybantam]

Hi all,

Could anyone offer me some help with what in principle looks like a simple task....

I've got a workbook which i've added a userform to, which allows the user to search for 1 or more fields on the click of a command button. I would like the search result rows to appear on a seperate worksheet.

I would also like the dropdown boxes on this userform to show only unique info, not multiples of the same entries.

I have attached my basic workbook below and would be very grateful for any help anyone can give.

Cheers, Busby

Car Stock List.xls

[MickG]

Try these 2 new bits of code:-

Please Login or Register  to view this content.

Regrds Mick

[busbybantam]

That's brill Mick, works a treat. Any chance you can explain to me how it all works??? If i've got a larger spreadsheet with many more columns which i'd like to search also, how would the code differ ??

[MickG]

Have a look at the remarks in the code below:-

Please Login or Register  to view this content.

Regards Mick

[busbybantam]

Thanks once again Mick, made it a bit clearer for me, but when i've tried to use the code on my actual table it's not returning anything. I've attached the file once again, but i've incuded the actual table and userform i'm trying to create (with all the sensitive data etc removed).
Is there any chance that you could give it the once over and see what my issue is ??? As you will see quite a few of the fields in the table are blank and not all of the columns are on the userform for the user to search with. Also, i'm wanting to use textbox's as well as combo box's.

With regards to the displaying of only Unique values in the combo box, is there anyway to not have the blanks show up in the combo box drop down list??

Sorry for all the questions, quite a bit of a newbie i'm afraid.

Cheers Busby

Car Stock List.xls

[busbybantam]

Thanks once again Mick, made it a bit clearer for me, but when i've tried to use the code on my actual table it's not returning anything. I've attached the file once again, but i've incuded the actual table and userform i'm trying to create (with all the sensitive data etc removed).
Is there any chance that you could give it the once over and see what my issue is ??? As you will see quite a few of the fields in the table are blank and not all of the columns are on the userform for the user to search with. Also, i'm wanting to use textbox's as well as combo box's.

With regards to the displaying of only Unique values in the combo box, is there anyway to not have the blanks show up in the combo box drop down list??

Sorry for all the questions, quite a bit of a newbie i'm afraid.

Cheers Busby

Attachment 174627

Can you help with the above post Mick ???

[MickG]

There appeared to be a misalignment between the Columns "Ac" number and the Array "Ray", "Ac" number.
Try this:-

Please Login or Register  to view this content.