Amend filter code to work with combobox

hi there,

How do you use this filter using the combobox on UserForm and can this be use to filter all worksheets or Active sheet only?

http://174.133.212.43/showthread.php?t=652340


Regards,

Max