Display contents of a cell in a user form text box -- Excel 2003 VBA

[hiskilini]

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

 

[Guest]

You should be able to set the value before the form is open.

Userform1.textbox1.text = "Mystring"

 

[hiskilini]

You should be able to set the value before the form is open.

Userform1.textbox1.text = "Mystring"






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

 

[Guest]

Does this work for you?

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

 

[hiskilini]

Does this work for you?

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






- Show quoted text -

Yes--that works perfectly. Thanks so much for your help!

John

 

[Guest]

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.

 

[faiz2011]

Does this work for you?

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

What if we select the value from range ??

 

[faiz2011]

What if we select any value from range in one column??