Copy from Cell Ref to TextBox Ref

[tudor30]

I apprecaite the assistance...

How would I copy:
From Workbook A, Sheet 1, Cell A1

To: Text Box 1 on Sheet 1 of another workbook

Thanks for suggestions,
John

 

[SkipVought]

Hi,

There's a DIFFERENCE between COPY and ASSIGNING a value. THis is a value assignment...

dim ws1 as worksheet, ws2 as worksheet
set ws1 = workbooks("thisname.xls").Sheet1
set ws2 = workbooks("thatname.xls").Sheet1
ws2.textbox1.text = ws1.[A1]
...
set ws2 = nothing
set ws1 = nothing

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884