Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word Control in Excel
Using Office 2000, I open Word and in a new document
I insert a Textbox. I then copy and paste it into a worksheet. I cannot find a way to programmatically refer to it. Sub Test() Dim oleObj As OLEObject, rng As Range For Each oleObj In ActiveWorkbook.Sheets _ ("Contract Master Order").OLEObjects If TypeOf oleObj.Object Is MSForms.TextBox Then Set rng = oleObj.TopLeftCell rng.Value = "Bingo" End If Next End Sub The 'If' statement gives the error: User defined type not defined How do I control the Textbox, please? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
Word wrapping in Text Box Control feature | Excel Worksheet Functions | |||
how to control word from excel | Excel Programming | |||
Print Control in Word/Excel | Excel Programming | |||
Print Control in Word/Excel | Excel Programming |