Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text and TextBox problem
With a textbox from the Drawing toolbar, how do I
programmatically load the textbox with loads of text? ActiveSheet.Shapes("Text Box 10").Visible = True ActiveSheet.Shapes("Text Box 10").Select ' Selection.Text = "ABC" 'this works 'the following does not work Selection.Text = _ "Use this Fax template to create the first Fax for a new" & _ vbNewLine & "Contract." & vbNewLine & vbNewLine _ & "Enter all those items that will be 'standard' for every Fax." Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with TAB key and Textbox controls | Excel Programming | |||
Excel VBA TextBox problem | Excel Programming | |||
Textbox problem | Excel Programming | |||
Problem with TextBox & ControlSource - Please Help | Excel Programming | |||
Excel textbox problem | Excel Programming |