Data filter from a ListBox

[Glenn Kennedy]

On may occasions I've commented that I know nothing about VBA. Here's the ultimate proof.

I have a listbox that dumps a named output into A2. I want that value to trigger a data filter in Table2 (the only Table shown on my example). When I select another value from the listbox, I need some code to ensure that the appropriate filter is applied.

if I click "A" in the listbox, I want the Table to be filtered to show only the entries for A in column A;
if I click E in the listbox, I want the Table to be filtered to show only the entries for E in column A;

this is SOOOO simple, I hate asking... But that's life.

[rajansettu]

Hi welcome to forum,

Please try the attached one(check)..

once you got answer for your question please mark your thread as completed.

[Glenn Kennedy]

I knew it was simple. It needed a slight tweak to associate "check" with the listbox & it seems to work fine.
I wish I knew something about VBA.

I'll try this out on my main sheet & get back to you...

[Glenn Kennedy]

Very nearly exactly what I want. My fault for not explaining properly. The first item on the listbox should be the default, unfiltered table - showing all data. Can you amend the code in Check?

[rajansettu]

Hi gleen,

Sorry for late reply

Copy the given code for autofilter and in the first line make below changes and try
Use this in the check (criteria >= "criteria")

rajan