How do I use a Userforn TextBox with Autofilter

[woodie_uk]

Hi,

Can someone help?

I would like to create a userform whereby a user would enter a criteria value and autofilter would use these values to select the right record.

However, the autofilter selection/filter criteria would not always be continuous

i.e. a user may want to enter a value in field 1, 2, 3 & 4 for the first attempt but for the second attempt they may only need to use field 1 & 4 as the autofilter criteria. in other words some of the textboxes in the userform would be empty at various times. How would i acheive this ?

I thank you in advance

Rob