checkbox that keeps portion of rows that contain specific text

[shivernoz]

Hi excel forum, this is a great site always useful to me. i need some help with VBA in excel.
Im trying to write a simple macro for a checkbox. ive attached a sample worksheet to this post, hopefully it shows a before and after example.

what is needed is = when I check the extreme low flow checkbox I need each gage (all 3 gages) with the specific text(extreme low flow) in their row to stay visible, and all other rows not containing the specific text to delete when unchecked.

For example, if i check extreme low flow each gage with a row that contains extreme low flow with keep the row and delete the rest. Not filter, the rows must stay exactly where they are, its date sensitive.

Im having a difficult time writing this out, so check the example attachment
dashboard_gages_excelforum.1.xlsm

[watersev]

hi shivernoz, I'm not sure I understood your "not filter" remark but check the attachment. Checking - leaves extreme low flow rows intact, unchecking - deletes everything except header.

The code does not use linked cells table in B:C columns.

[shivernoz]

Hi watersev, this works well except that when unchecked instead of deleting everything, id like to see all the data again.

[watersev]

will it be acceptable to change font color to white for unnecessary data on checking?

[shivernoz]

sure that sounds good!

[watersev]

please check attachment

[shivernoz]

Now that is impressive, I thank you for you time towards this.

[shivernoz]

Quick question If i wanted to change the extreme low flow to high flow, what would i need to change in the code to do this?? I tried replaced just extreme low flow to high flow but this doesnt do anything.

[shivernoz]

This attachment works well, but instead of changing the color, is it possible to just delete the unecessary data when checked, then when unchecked it goes back to normal?

[watersev]

Quick question If i wanted to change the extreme low flow to high flow, what would i need to change in the code to do this?? I tried replaced just extreme low flow to high flow but this doesn't do anything.

You should write the "filtering" string correctly: "extreme low flow" or "high flow pulse"

Option to make it with deleting contents of the unnecessary cells

[shivernoz]

Thank you, I did try it with the correct filter high flow pulse, but it didn't work. Anyway I tried it with the current up to date version and it performs great. West Texas thanks you! This is for a hydrological water budget of the Rio grande, and how climate has effected the river, you have helped so much.