Hello There,
I have a excel table defined. Created a Userform with 3 objects:
1. ComboBox: Which will display all the Table column names
2. TextBox: Enter the value to be searched for the Table Column Name selected above.
3. Button Search: On pressing, it should show up the row for the above given points 1 & 2
4. Button Reset: On pressing, it should clear all the filter values on the worksheet.
5. Cancel: Rest & close the UserForm.
This can be achieved using the filter options in the Table. The users are real non-excel users with min. knowledge. That is why this requirement.
Please advise. I have attached the sample workbook for your reference and a jpeg file for the final output.
Looking forward to hearing from you.
Regards
Don
I have a excel table defined. Created a Userform with 3 objects:
1. ComboBox: Which will display all the Table column names
2. TextBox: Enter the value to be searched for the Table Column Name selected above.
3. Button Search: On pressing, it should show up the row for the above given points 1 & 2
4. Button Reset: On pressing, it should clear all the filter values on the worksheet.
5. Cancel: Rest & close the UserForm.
This can be achieved using the filter options in the Table. The users are real non-excel users with min. knowledge. That is why this requirement.
Please advise. I have attached the sample workbook for your reference and a jpeg file for the final output.
Looking forward to hearing from you.
Regards
Don