Active X Check Box that will perform certain macros based upon cell values

Hi Guys,

I am somewhat a novice with VBA/Macros, that pretty much learns from trial and error, but I can't seem to figure this one out!

Objective:
I want a ActiveX Checkbox that will do the following when checked:
It needs to do 2 different functions based upon the value input in cells Q4:R4.

1. if cell Q4:R4 value = 1, hide rows 48 through 48 and perform a formula (type "Yes" in C73:D73)
2. if cell Q4:R4 value <1, do not hide rows and perform formula (type "Yes" in C73:D73)

Unchecked:
Reset the above functions...

Thanks for your time!


#

Please Login or Register  to view this content.

#

Originally Posted by houseflipsheet

1. if cell Q4:R4 value = 1, hide rows 48 through 48 and perform a formula (type "Yes" in C73:D73)
2. if cell Q4:R4 value <1, do not hide rows and perform formula (type "Yes" in C73:D73)

By this, do you mean the sum of the values of the 2 cells = 1? or value of both individual cell = 1?

So I assume C73:D73 is merged as well, try this.

Please Login or Register  to view this content.

If you want it to be changed on changing of values as well, you will need the worksheet change event code.

Try placing this in the worksheet's code, should be Homeowner Offer Report worksheet.

Please Login or Register  to view this content.