Automatically Show or Hide row based on cell value

[tomdegroot]

Hello

So I made an example file with 2 tabs "InformationSheet" and "FinalTable".

Based on the value "ok" in "InformationSheet", a row gets added in "FinalTable", the row gets implemented in the sheet "InformationSheet", if the "ok" gets deleted, the row also gets deleted.

I also have a macro that hides or shows that row based on the cell value in J8, if this cell is empty, the row needs to be hided, if this cell is not empty, the row needs to be shown.

The macro works fine, but I rather have this macro to run automatically, instead of running the macro manually everytime...

I hope this is possible!

King regards

[dangelor]

Hello Tom...

It's probably possible, but what would trigger the macro to run automatically?

• When the workbook opens?
• When a worksheet activates?
• When a specific cell or a range of cells are selected or changed?
• Etc...

There are quite a few different triggers one can use in Excel.

[tomdegroot]

Hello!

Basicly whenever the value of cell J8 changes in "FinalTable"

If this cell is empty --> Hide Row

If this cell is not empty --> Show this Row.

Hopefully I've made these things clear how I want to make it run automatically!

[dangelor]

Try copying this to the "FinalTable " worksheet code module...

Please Login or Register  to view this content.

[tomdegroot]

Thank you! This was exactly what I was looking for!