Filling Userform in Word with Excel cell value.

A

AW

I am opening a Word document from Excel. I then wish to take a cell value
from excel and populate a textbox on a userform in Word.
Using the code below, the TextBox isn't populating and I'm getting a Run
Time error(438). Please can anyone point to the cause of the error.

MyDoc.UserForm("frmCCS").TextBox("txtCostNon").Value =
Worksheets("Sheet1").Cells(25, 5).Value


Thanks

Al@n
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel value onto word userform 2
Filling Userform in Word with Excel cell value. 3
How to apply NumberFormat to control on a Userform? 3
Using ControlSource property in Textbox in UserForm 3
Adding a big matrix in Word 2013 5
display $ sign in excel sheet 2
Data Val MultiSelect on Userform? 2
Check for values in column A and if found then column B must have value. 3

Top