| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drawing text on a worksheet
I would like to add a block of text on top of a worksheet (Excel XP) using VB
Express 2008. When I use .AddTextBox to add text to a shape, I seem to be limited to 255 characters, and I don't know how to control the font attributes. Anyone with more experience who can point me to a better solution? Thanks. -- Dave Ackmann |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drawing text on a worksheet
You could add a Word Object to get more characters
Set WordObj = ActiveSheet.OLEObjects.Add( _ ClassType:="Word.Document.8", _ Link:=False, _ DisplayAsIcon:=False) "DAACKM" wrote: I would like to add a block of text on top of a worksheet (Excel XP) using VB Express 2008. When I use .AddTextBox to add text to a shape, I seem to be limited to 255 characters, and I don't know how to control the font attributes. Anyone with more experience who can point me to a better solution? Thanks. -- Dave Ackmann |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drawing Objects with vba and workbook/worksheet | Excel Programming | |||
| How to Place a Drawing Object on a Worksheet as a Control? | Excel Programming | |||
| Text box in drawing toolbar in Excel | New Users to Excel | |||
| how to replace drawing with text in that cell | Excel Programming | |||
| inserting a VISIO drawing into a worksheet | Excel Worksheet Functions | |||
Linear Mode
