How to display content of cell in a text box Excel 2003 VBA

**!Jumala!** · 21-02-2012

I am trying to display the value of a static cell ("F3") in a text box within a user form. The user should not have to take any action to display this value--it is being used as a confirmation of a file creation and provides instructions as to what the user should do next. The value within the text box is the file name, which is being written to cell "F3" of my worksheet. Any help anyone could provide would be appreciated.

**-Deven-** · 21-02-2012

You should be able to set the value before the form is open. Userform1.textbox1.text = "Mystring". I tried that, but it did not work--the text box is empty. This is
what I have:

Code:

Private Sub TextBox1a_Click()
Dim myString
Sheets("Data").Select
Range("F3").Select
myString = Range("F3")
UserForm2.TextBox1a.Text = myString
End Sub

**JustineBB** · 21-02-2012

Does this work for you.

Code:

Private Sub UserForm_Initialize()
TextBox1.Text = Worksheets("Sheet1").Range("F3").Value
End Sub

You could also link the textbox to the cell using the controlsource property. In the textboxes property window, find the controlsource property controlsource: Sheet1!F3. This may not be desirable if you allow the user to edit the textbox.