Suggested vba code that applies to multiple check boxes

Greetings

An excel sheet is not necessary at present as a picture of the user-form will tell the simple situation.

Sampleform.JPG

I am looking for guidance to proceed with code to process approx., 100 check boxes (including the multi-tabs not shown). As shown on the sample form there are two check boxes per data-element; one to "Confirm" and one to "Update" the field directly to the right of the second check box.

Basically, I want the user to click the 1st check box (if no changes are required) and the word "confirmed" appear in the "revised value" text box.

If the data requires revision, then I want the user to click the 2nd check box and have the code put the cursor in the "revised value" text box for the users-input.

I have searched and see many different approaches; however, just looking for general good practice guidance for me to proceed as I am not very experienced in vba.

Your suggestions are most appreciated.

see big yellow banner - how to upload a workbook - enables us to give a far more comprehensive advice.
a casual observation - you also have 13 option buttons - what is there purpose as they do not seem to be separated - therefore only one would be selected.
torachan.

The option buttons are totally independent of each other and apply just to the line item to the left; such as "Acquisition Method Code".

I could easily create an event for each "option button" and include an IF statement to add the word "confirmed" in the "revised value" text box to the right of the "option buttons." See my explanation above.

However, I am seeking guidance on an alternate solution to NOT create a hundred events; perhaps there are other solutions more compact and more efficient.

And yes, I see the yellow banner; however, my form is enormous (works very nicely) and accesses a source file with 300 columns from an oracle serve. So the reason for the graphic and not an actual file.

Thanks,

By the way, I'm referring to the 26 "Check boxes" not the 13 "option boxes."

merely an observation on the side - there is nothing to show the option buttons are contained and independent of each other - can you select more than one
not many of us are prepared to construct a userform when one already exists.
just makes sense to help us to help you solutions arrive quicker then.

I agree with torachan comments fully. To add to them, any solution we might be able to suggest is probably going to be highly dependent on the names you gave to those checkboxes as well as the names you gave to the textboxes and how those names are linked to each other.

This is the type of guidance I am seeking, a methodology; however, I have to get knowledgeable on "custom classes". This approach does present a complex solution though and your suggestion is most appreciated.

I meant to say a "compact solution."