Copy a Textbox to a range on different worksheet

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Worksheet Range in a Textbox	=?Utf-8?B?cm9hZGtpbGw=?=	Microsoft Excel Misc	1	19th Oct 2007 02:43 PM
copy range on every worksheet (diff names) to a master worksheet (to be created)	Bernie	Microsoft Excel Programming	2	22nd Sep 2004 03:30 PM
copy range on every worksheet (diff names) to a master worksheet (to be created)	Bernie	Microsoft Excel Programming	0	22nd Sep 2004 03:26 PM
need help with form textbox to equal worksheet.range	GregJG	Microsoft Excel Misc	2	18th Jul 2004 11:07 AM
How? Macro to copy range to new worksheet, name new worksheet, loop	Repoman	Microsoft Excel Programming	9	9th Oct 2003 01:45 PM