I won't lie, I've been racking my brains to get around this.
I would like this srchusrfrm.jpg userform to be used in this way;
Combo Boxes - List headings of column (so out of 12 you can have up to three choices)
Text Boxes - In conjunction with the above outlined criteria, to search defined column, with textbox value
Search - actually searches active worksheet
ListBox - Displays results
Select - once highlighting the results it opens another Userform to allow the data to editted
Cancel - Saves workbook and closes userform
All the code I've wrote, found, researched and used have not seemed to have worked. I have even tried to macro the Filter system, but there are still problems. Either it only works with the combo box or just the text or the text populates the list box... I just can't seem to get my head around it. >.<
Unfortunately I can not attach the file as it is too big, all help is appriciated, Thank you in advance.
Bookmarks