Option Button _Before Update event linked to Combo box

[vx7g3]

Hi,

I have various options buttons (sets of 5 options buttons) linked to each combobox (Yes/No) as shown below in the picture. I want to basically create a loop where i can cycle through the before update event and check whether the corresponding combobox has a "No" value in order to make the options button value=True

I am currently doing it for each option button ....is there a shorter loop that i can use?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Capture.JPG

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[vx7g3]

Thanks ..sorry about the

Please Login or Register  to view this content.

tags ..will keep that in mind in the future.

[mikerickson]

I would use a different approach. Enable the OptionButtons only when ComboBox419 <> "False"

Please Login or Register  to view this content.

[vx7g3]

Thanks Mikerickson ...this works for me ..thanks for helping!