Change the value of radio button in Excel

Hi there

Please help! I have a LS action that makes changes to an existing Excel spreadsheet. On the Excel spreadsheet is a radio button with 10 options - how can I set it to a certain value?

thanks!!

Subject: Change the value of radio button in Excel

Check the properties of the button - does it have a Linked Cell ? If so, changing the value of the cell will change which button in the group is selected.

Subject: RE: Change the value of radio button in Excel

It worked, thank-you Graham!

What about a list box?