On Feb 19, 8:10 am, Joel wrote:
You should be able to set the value before the form is open.

Userform1.textbox1.text = "Mystring"



"hiskilini" wrote:
Hello,

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!

Thanks,

John- Hide quoted text -

- Show quoted text -

I tried that, but it did not work--the text box is empty. This is
what I have:

Private Sub TextBox1a_Click()

Dim myString

Sheets("Data").Select
Range("F3").Select
myString = Range("F3")

UserForm2.TextBox1a.Text = myString

End Sub

Thanks.