Retrieve Value from Group of Controls

[christic197824]

All,

I am not a programmer, so please excuse my wording:

In Excel, I have created a group of Radio Buttons which are functioning properly. However, when one is selected, I would like to retrieve the value on another sheet in the workbook. How do I achieve this?

Thanks in advance,

Chris

 

[Fazza]

Hi, Chris

Can you go to the properties of the control and set the 'linked cell'? Do so for each control and link to a cell on the same worksheet as the controls. Check & see that it is working as expected. From the other worksheet, put in formulas to get the result there from the sheet that contains the controls.

HTH