Reading Data from a Cell to a text box-user forms

[[email protected]]

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...

[Leith Ross]

Hello Mandle,

The code you have is correct but not the references. It needs to be placed in the TextBox's Activate event procedure.

1) Copy the code below using CTRL+C.
2) Open the Workbook you will using the code in.
3) Press ALT+F11 to open the VBA Editor.
4) Click on the + (plus sign) next to Forms in the Project Explorer to display the forms in your project if they aren't listed.
5) Double Click TextBox 70.
6) Place the blinking cursor at the top left side of the listed code.
7) Press CTRL+V to paste it in.
8) Press CTRL+S to Save the changes.
9) Press ALT+Q to return to Excel.

Please Login or Register  to view this content.

Sincerely.
Leith Ross