Multiple Checkboxes to filter

I want to thank anyone who helps me first.

I am very new to macros so i might be getting too far ahead of myself with this. I have a multipage userform, and on page2, if page 1 is 0, I have a frame with 18 difference checkboxes. I want to be able to select more than one at a time and have them filter column C on Sheet1 for any cell that contains the caption of any checkbox selected. Is this at all possible. I think i have read every forum on the matter and can't find exactly what i need.

Right now the checkboxes filter the first one selected and subfilters every one checked after that point.

Downstream 14.0.xlsm

Thanks John,
I really do appreciate your help.
I am still having two issues with this.
I am just assuming what causes it, is that I have more than one option listed in a single cell. It seems to only pull the items if they are listed individually. Is there anyway to change this to a "all cells that contain this prefix" type of situation?
The other issue is it seems to only generate one result at a time. I have some heavy formulas in the database on the spreadsheet and I don't know if this is whats causing some problems.

I plugged in a few pieces of dummy information.
Capture.PNG

Sorry,
Here is the doc with some fields filled in.

Downstream 14.1.xlsm

You are amazing!
Thank you so much!

I don't honestly know at this point. This is a base for a huge project. There are times where it will be probable.

No worries. Thanks for all your help so far. I might not respond quick after tonight. Driving to Florida tomorrow.

I am sorry I didn't write sooner. In addition to your statement about how if a checkbox is selected that is not listed it returns nothing, I am also having an issue where if I dont make a selection at all it gives me an error. I am thinking I could just add a no filter checkbox or something that could fix my other problem but after reviewing your note, yes I would need that to be functioning if a checkbox is selected.

The code seems to work great. However, now my clear search button does not seem to clear it 100%. It seems to clear all the results which is great but the cells that were hidden are now remaining hidden.

Private Sub CommandButton2_Click()
Worksheets("Sheet4").Range("J1") = ""
Worksheets("Sheet1").Range("D2") = ""
If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

End Sub


I am also worried about the size of the file since it is not yet completed. There will be thousands of combinations of results. I would love to try and remove the formulas in sheet1 to condense it down some more. However, my skill level is limited. I don't know if there is an option to have the userform return the results without using the formulas.