View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rmandle@gmail.com is offline
external usenet poster
 
Posts: 4
Default Reading Data from a Cell to a text box-user forms

There was a post about this recently, but I don't know where to put the
actual code! As you can tell I am somewhat of an amateur.

I need a text box (TextBox70) in a user form to automatically reference
a cell ("Index!B2") on a worksheet when the form opens. Any ideas on
how to do this? I think the code is:

TextBox70.Value = Sheets("Items").Range("a3").Value

....but not sure exactly where I need to paste it into the VB editor...