Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel value onto word userform
Hi
I'm trying to import an excel cell value into a textbox on a word userform. I've managed(with the help of code found in the forums to open a document based on a word template and get the word userform to display but cannot get the cell value to populate the textbox on the word userform. Example code below(Office 2003) ________________________ Private Sub cmdQuote_Click() Dim WD As Object Dim MyDoc As Object Set WD = CreateObject("Word.Application") With WD Set MyDoc = .Documents.Add(Template:= _ "C:\Documents and Settings\Owner\Desktop\Gas Quotation.dot", _ NewTemplate:=False, DocumentType:=0) MyDoc.Activate MyDoc.UserForm("txtAdd1").Result = ActiveSheet.Range("C8").Value '********** ..Visible = True End With End Sub __________________ TIA -- Al@n |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Word crash when I try to add a UserForm | Excel Programming | |||
Inserting contents of a Word document into a Userform in Excel | Excel Programming | |||
transfer data from word userform to excel | Excel Programming | |||
Open Word Document from Excel Userform | Excel Programming | |||
Filling Userform in Word with Excel cell value. | Excel Programming |