i have two different workbooks, in one workbook i have put in radial buttons, in the other workbook i want in to put something in a specific cell when the radial button in the other workbook is true. they are two different worksheets in to different workbooks. i think you need to use vba but i dont know the string. please help.

You can't. "Radial" buttons do not exist, therefore you cannot test for them. If you meant radio buttons, then that's a different can of worms. In the document that you want the value, your Sub should look something like... Sub Something Dim book As Excel.Workbook Set book = GetObject("Path & name of first book") If i.Worksheets(?).radio1.Value _ ThisWorkbook.Worksheets(?).Range("A1").Formula = Whatever End Sub