Option Button "Linked Cell" Property
Does the "Linked Cell" property in an Option Button (Activex Control) work in the same fashion as the linked cell in used an option button in the Forms toolbar?
For example, with the invaluable help of Carlos Paleo, I am refining the design of a worksheet whereby two option buttons will hide or unhide two sets of rows. Depending on the selection made by the user, one of the two sets of rows will be aggregated on the bottom of the worksheet.
If I were working with an option button from Forms, I would enter a simple formula choosing the rows to aggregate depending on whether the linked cell displayed 1 or 2. How does this work with an Activex control?
Linked Cell property in Option buttons
Jake, thanks for the post. I understand however that your code will simply cause message boxes to pop up, depending on whether the user clicked on Option Button 1 or Option Button 2.
What I really need is for the option buttons to place a distinguishing value in cell G4 (which happens to be available!); this could be a TRUE or FALSE statement, or the values 1 or 2 (indicating whether option box 1 or 2 was clicked). This will enable me to use a logical Excel function to determine which rows should be summed up. For example, if the value in cell G4 is "1", rows 5, 10, and 15 will be aggregated; if it is "2", rows 6, 11, and 16 will be aggregated.