Macro to print filtered results of user data?

[JumboCactuar]

Hi,
Im not too good with vba

Im wanting a combo box which lists user names.
Then for the selected user i want to print filtered data for that user

Example
If "Bob" is selected in the combo box,
After pressing "Print Data" button:

Filter Sheet 1 for bob records
Print data
Then clear filter

Thanks for any help

 

[JumboCactuar]

bump
can anyone help with this?

 

[JumboCactuar]

Bump