Re: Creating TextBox in Excel
Re: Creating TextBox in Excel
- Subject: Re: Creating TextBox in Excel
- From: Jay Young <email@hidden>
- Date: Wed, 11 Sep 2002 22:23:34 -0500
It looks like this works for adding text to a text box in Excel:
tell application "Microsoft Excel"
Activate
set text of TextBox 1 of Worksheet 1 to "hi there"
end tell
So far, I still can't figure out how to create the Text box though.
Here's some code I've been working with (it gives me a 'Can't continue
Create' error):
tell application "Microsoft Excel"
Activate
Create New TextBox At ActiveSheet With Properties {Top:100, Left:200,
Height:40, Width:40}
end tell
Jay
On Wednesday, September 11, 2002, at 04:50 PM, Jay Young wrote:
>
Hi,
>
>
I was wondering if it's possible to create a text box (from the
>
'Drawing' toolbar) in an Excel worksheet. I have found the term
>
'Textbox' in the Excel Dictionary but I can't figure out the syntax to
>
add a new text box into a worksheet and then fill it with text.
>
Thanks for your help.
>
>
Jay
>
_______________________________________________
>
applescript-users mailing list | email@hidden
>
Help/Unsubscribe/Archives:
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
>
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.