I have been searching the depths of the internet to try and find the answer to this problem and just cannot find what i need.
I am creating an Index to house a list of projects and i want the user to be able to filter the projects (which are all listed in the rows below the selection criteria) by selecting one option button and then as many checkboxes as necessary. The default setting is that the option button is selected for "All" and the checkboxes are all checked (True). I have pieces of code that i have been trying to string together but nothing seems to work. I need the checkboxes to further focus the search criteria of only "unhiden" rows and not every row (based on the option button selection, then, given what is left, further hide rows that are unwanted).
The option boxes are the project "Category", which there are 3 options to pick from, this value for each project is in column B and the "Subcategory" for the project will be the checkboxes (up to about 6) and these are also set values to choose from and are in column C. I want to sort for the range where there are values (Only sort in the range where there are projects).
Hopefully this all makes sense. I am new to visual basic and clearly struggling.
I am creating an Index to house a list of projects and i want the user to be able to filter the projects (which are all listed in the rows below the selection criteria) by selecting one option button and then as many checkboxes as necessary. The default setting is that the option button is selected for "All" and the checkboxes are all checked (True). I have pieces of code that i have been trying to string together but nothing seems to work. I need the checkboxes to further focus the search criteria of only "unhiden" rows and not every row (based on the option button selection, then, given what is left, further hide rows that are unwanted).
The option boxes are the project "Category", which there are 3 options to pick from, this value for each project is in column B and the "Subcategory" for the project will be the checkboxes (up to about 6) and these are also set values to choose from and are in column C. I want to sort for the range where there are values (Only sort in the range where there are projects).
Hopefully this all makes sense. I am new to visual basic and clearly struggling.
