Quick question

[Rockhopper3]

Just a quick question. I have a userform set up and I want the textbox2 to have text entered into it automattically when the user form opens. It needs to have the value of cell "I3" in it. Thanks.

 

[jindon]

Hi
Something like this in the form module

Private Sub UserForm_Initialize()
  Me.TestBox2.Text = Sheets("YourSheetNameHere").Range("i3").Value
End Sub

 

[Rockhopper3]

The user form will be used on 13 different sheets. I need the value of "I3" of the active sheet to appear in the textbox.

 

[jindon]

The user form will be used on 13 different sheets. I need the value of "I3" of the active sheet to appear in the textbox.

just change

Sheets("YourSheetNameHere") to

ActiveSheet