Using option buttons and textbox for searching listbox

Hi there,

I'm sorry for not providing any code here, I have never used these two controls in excel (Searched the net and not finding anything relevant). So here is what the goal of this form. User enter Department name in the txtDepartment and select "In" or "out" in the option group, and the listbox requery for that selected options.

Hoping to learn from your expertise. Thank you all!

see attached snapshots.