pop up menu with options to select

Dear All,

I am trying to create a macro to be with assigned to a button with my little knowledge of VBA, maybe you can give me a hand.
What I want to do with the macro once I click the button is:

- open a pop up menu containing a list of options
- user select one or more options
- specify a cell where to paste this options
- close the menu

Then I am trying to build another macro related to a second button that:

- open a pop up box
- select one or more options
- filter the table and show only rows containing selected words in a specified column.

Is it something doable or do I have to give up on this ?
Any help would be HIGHLY appreciated.

Thanks
Luca

OLLY THANK YOU SO MUCH !!

it is definitely the right direction. button 1 is exactly what I wanted. I can select the options I want and the cell where to paste. Button 2 for the filtering is almost there. If I have multiple options in the same cell, the filter will pick up only on those cell with one option selected in the userform. I just want to show any row containing selected options in the userform, whether or not these are one entry only or within multiple entries in the same cell.

Does this make sense ?

Thanks A LOT for helping me with this, I spent 3 hours trying to sort it out myself with no success

hey Ollie, sorry for not gettin back to you sooner.

Yes, if I try to look for 3 or more 'option' in the column it doesnt show me anything at all.
Also I am trying to change the code for what I need, I managed to change the options with the services and I tested it in my spreadsheet, first button works fine. The second does not filter as I have multiple columns in my table.
How do I tell to analyse that specific column containing the key words instead of starting for the first one? The first column is a counter so because the filter looks there, it 'zero's' everything

Thanks again for your patience !!!!!!!!!!

great, second problem is sorted.

I just need to bring up the cells (and therefore the row) containing the words I select in the popup box, they are not meant to be combined.
So if I select Alfa, Bravo, Flower, I want the filter to bring up all the cells containing Alfa,Bravo,Flower in that specific column (that I now know how to define, thanks!!), it doesn't matter if in those cells there are other options or items or whatever u call it as long as the filter picks up the cells containing at least one of the selected words. Not sure I can do that...?

I am super grateful for this, thanks a lot and sorry if I keep bothering you with all these messages!!!

ok ! I will work around that, 2 might be enough
thanks again, you have been super helpful

ok I will try this one as well !
I guess I need to change the number of the column to make sure it looks in the right place..?

filterData = Sheet1.ListObjects("Table1").DataBodyRange.Columns(1).Value2

Awesome !! I am just testing it but it seems like working fine with whatever option I pick up !!

I did make these changes to make sure it was looking at just one column but please correct me if I am wrong..

filterData = Sheet1.ListObjects("Table1").DataBodyRange.Columns(1).Value2
...
If .Count > 0 Then Sheet1.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:=.keys, Operator:=xlFilterValues

I didnt get any message of error and it seems to filter accordingly to the specified column

yes, it is the same, I just highlighted in red what I changed in my version, name of the sheet, table and column
But again, I must have changed accordingly and correctly because it works fine, no matter how many options I select, it gives me the rows showing specified words in the pop up window. Thanks a lot you to you both !

Hello it is possible to adpat this file in button 2 in order to select not with options but with text through a text box? I need to insert some partial text and then OK and it applies the filter.
Thanks a lot