View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
KellTainer[_2_] KellTainer[_2_] is offline
external usenet poster
 
Posts: 1
Default cell value to text box?


Try this in the event procedure that you activate to transfer the value

Lets say your UserForm = UserForm1
and TextBox = TextBox1
and Sheet = Sheet1

UserForm1.TextBox1.Value = Sheet1.Range("A1").Value


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548293