Using a Checkbox to Unhide Rows

[briggss1]

I need to unhide rows on a separate sheet based on a condition where I click a checkbox, then the code would look up a range and if there is an "x" in that range, unhide the rows the "x" is in. Example:

On Sheet 1, I have three selections. I want to select one of the 3 and this will unhide resulting cells that are flagged with an X on sheet 2

Sheet 1 - B would be a check box

Sheet 2 - all information displayed. These rows will all be hidden by default. By selecting "Fajitas" on Sheet 1 (control box), I want the macro to run and lookup Sheet 2, find the Fajitas column (Col B), and unhide all of the rows with an "x" in column B. So the progression would look like this:

This is the default state of Sheet 2. When the Fajitas radio button is clicked on Sheet 1, Sheet 2 will unfilter all rows where the Fajita column conytains an "x" as follows:

After all data is done, I will have a Reset macro that will return all data rows back to hidden on Sheet 2.

 

[DanteAmor]

click a checkbox

When the Fajitas radio button is clicked on Sheet 1

In your request you mention a checkbox, a radiobutton but in your image you have the 'x' in a cell.
Also you don't mention if the control is a Form control or an ActiveX control.
That way it's hard to try to create code assuming what the controls are like on your sheets.

--------------------​

I show you a way to filter without code and I think it is more practical:

1. In your datasheet, select your data and create a table.

• Select a cell within your data.
• Select Home > Format as Table.
• Choose a style for your table.
• In the Create Table dialog box, set your cell range.
• Mark if your table has headers.
• Select OK.

2. Use slicers to filter data

• Click anywhere in the table.
• On the Insert tab, select Slicer.
• 
• In the Insert Slicers dialog box, select the 3 data
  
  
  
  
• Then select OK.

• A slicer will be created for every field that you selected.
  
  

• Adjust the width and height of each button to show only the 'x'
  
  

• Press the 'x' on any of the slicers to filter the column, for example in Fajitas:

• To clear a slicer's filters:

--------------
What do you think about this way of filtering without codes and everything on the same sheet.

If you still want the code, you'll need to be more specific in your request.

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​