Mime-Version: |
1.0 (Apple Message framework v930.3) |
Content-Type: |
text/plain; charset=US-ASCII; format=flowed; delsp=yes |
Date: |
Sat, 23 May 2009 22:47:04 -0400 |
Reply-To: |
|
Subject: |
|
From: |
|
In-Reply-To: |
|
Content-Transfer-Encoding: |
7bit |
Sender: |
|
Parts/Attachments: |
|
|
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
|
|
|