ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filling Userform in Word with Excel cell value. (https://www.excelbanter.com/excel-programming/294099-filling-userform-word-excel-cell-value.html)

AW

Filling Userform in Word with Excel cell value.
 

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").Val ue =
Worksheets("Sheet1").Cells(25, 5).Value


Thanks

Al@n




All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com