View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default Copy a Textbox to a range on different worksheet

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