Hide multiple ActiveX checkboxes with name as variable when a cell is returning blank

Hello, people!

I have a problem with ActiveX checkboxes. I have a formulas on column G which sometimes return blank based on a criteria. I have ActiveX checkboxes next to each cell on the next column (H). I want those ActiveX checkboxes to be hidden then the formula in the adjacent cell on column G returns blank. The checkboxes are named cbWin1, cbWin2,... and so on. This is the code I've tried and it doesn't work:

Please Login or Register  to view this content.

Any ideas!

Thanks a lot!

And that below is exactly for one line with a change in "G" to blank cell, but the index of the given "cbWin" must correspond to the given line, i.e. if Target.Row = 2, then the corresponding checkbox must be "cbWin2":

Please Login or Register  to view this content.

Thanks, guys, for the quick replies.

I daveexcel's solution with Worksheet_Calculate() instead of Change, and I get a 424 object required error on the first line. Porucha's returns the same error on the same line, the If Target one.

I need the checkboxes to disappear when the formula returns a blank. Actual changes to the source that modifies the result happen in a different sheet.

Any ideas?


Thanks!

Originally Posted by cristihendrix

and I get a 424 object required error on the first line

at my place it works, below is a screen in mp4 file (works with mpc-hc player)

Works perfectly!

Thanks Porucha, thanks davesexcel! You're great!

Sorry guys, I just realised that davesexcel method, which I've used, doesn't work when I have other checkboxes in other columns. I need these other checkboxes to be hidden when the formula in the G column returns blank. So all the checkboxes have to be connected to the G column, not to the column just left of the checkbox.

Can that be done?

Thank you!

All checkboxex in the whole sheet, or just these which correspond to their position with rows with empty cells in column 'G'?
what's your excel spreadsheet look like ?