Hi,
I have written some code in order to hide rows based on a checkbox. Initially I wrote the code to hide rows based on a value in a cell and it worked fine, however when i moved to a checkbox it did not work. I have pasted part of the code below.
Also the hide and unhide of rows never worked properly can someone please help.
Please Login or Register to view this content.
Last edited by jeffreybrown; 03-26-2020 at 02:20 PM. Reason: Please use code tags!
Hi,
I think you can have better results when you use instead:
CheersPlease Login or Register to view this content.
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Hi & welcome to the board.
Rather than checkboxes, which don't trigger a change event, why not just put an X in the cell instead?
I tried using X as the trigger in a cell based on the checkbox =TRUE/FALSE and got mixed results. I think I need to work on a better VBA code.
Thanks so much I will try what you suggest and see how it works out.Originally Posted by Eastw00d
Hi,
I think you can have better results when you use instead:
CheersPlease Login or Register to view this content.
Erwin
Maybe this is what you are looking for:
CheersPlease Login or Register to view this content.
Erwin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks