Prev: Macro to ransfer data
Next: disable macro/code after date & time
From: LRay67 on 20 Apr 2010 11:50
Can someone please assist me in how I would go about copying a textbox value
to a specific range in same workbook but different sheet?

Thanks in advance

LRay
From: Gary Brown on 20 Apr 2010 14:53
This is the syntax...
Sheets("Sheet1").Range("C4").Value = _
Sheets("Sheet2").TextBox1.Value

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"LRay67" wrote:

> Can someone please assist me in how I would go about copying a textbox value
> to a specific range in same workbook but different sheet?
>
> Thanks in advance
>
> LRay
 | 
Pages: 1
Prev: Macro to ransfer data
Next: disable macro/code after date & time