I worked out a solution that functions but is very slow so if anyone has a better method I'd appreciate seeing it ... tell application "Microsoft Excel" tell workbook 1 tell worksheet 1 set theOptionButton to every option button whose name is "options_yesno" and caption is "Yes" set the value of item 1 of theOptionButton to checkbox on end tell end tell end tell John Duncan JEDtech Consulting, LLC [log in to unmask] On May 22, 2009, at 10:00 PM, MACSCRPT automatic digest system wrote: > Date: Thu, 21 May 2009 23:54:14 -0400 > From: John Duncan <[log in to unmask]> > Subject: Scripting Option Buttons in Excel > > Can anyone point me in the right direction for scripting multiple > "Option Buttons" (radio buttons) in Excel? If I have 2 option buttons > with the same name they behave as a group and are mutually exclusive. > I.E. if I have to Option Buttons both named "options_yesno" and one > has caption "Yes" and one has caption "No", if you click Yes, then > "No" deselects an vice-versa. > > The problem is I can't figure out how to address any but the first > option button. The following code selects the "Yes" radio button > which is the first one but I can't figure out how to address the > second one to make "No" select. > > tell application "Microsoft Excel" > activate workbook theDocument > tell workbook 1 > tell worksheet 1 > set the value of option button "options_yesno" to checkbox on > end tell > end tell > end tell