Using option buttons and textbox for searching listbox

[sniper1]

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.

[Keebellah]

Hi, what Office version is WA?
If you cannot provide code you have the sample from which you posted the image, can't you attach that?
Will make it easier to explain and 'show'

[karmapala]

Maybe something like this that you want ?

Please Login or Register  to view this content.

2020-06-01_16-17-24.gif

You need to name your "search" button to SEARCH,
name the text box for Department as DEPT
And also need to add one button with name CLEAR.

[sniper1]

karmapala,

Thank you for your assistance, here is what I am getting. Autofilter method or Range class failed (Run-time error '1004'). Also the sub routine for PopLB is that a module(a minor correction: made it a Private sub).

[Keebellah]

No go for me without a sample file

[sniper1]

No worries, figured out what was wrong, your code works like a fine wine, just user error. Thank you very much!

[karmapala]

No worries, figured out what was wrong, your code works like a fine wine, just user error. Thank you very much!

You're welcome, sniper1.
Glad the code works for you.

[sniper1]

Sorry for the last minute question. Is there a way you can show us how to filter a sheet with slicers? Thank you.

[karmapala]

Sorry for the last minute question. Is there a way you can show us how to filter a sheet with slicers?

I'm sorry I don't know how to filter a sheet with slicers, sniper1.

Currently I have Excel 2010, and as far as I know, make a slicer option is just for a pivot table.

Maybe you can google it ?
This link maybe can help you.

[Keebellah]

@sniper1: a slicer is already a filter