Hide Option Button based on Linked Cell Value

Hi Jeff,

Thank you for your response. I used Worksheet_Calculate since the Values in "E7" and "E8" are based on the selection of option buttons in particular groups. The Worksheet_Change function will not activate the code.

I do not understand why a change in cell "E8" triggers the code to run, but not a change in cell "E7".

Hi Leith,

I have to admit I am new to VBA coding and know nothing about UserForm. Is there a tutorial available I could use?

Thank you!

A 'User Form' would be a cool interface for this project.

However, here's a quick way to force the 'calculate' event and macro when either cells E7 or E8 is changed by selecting various buttons.
Just add a formula like = E7 + E8 in an unused cell.

It seemed to work in your example when I tested it.

Optionally, you might want to extend that to add all the code values for the various button groups.

Hi StruCram,

Such a simple solution! Thank you! I'm going to look into User Form for this as well since I'm in the early stages for a few month project.