Originally Posted by Tom Ogilvy

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.

--
Regards,
Tom Ogilvy


"hiskilini" wrote:

On Feb 19, 8:21 am, Mike wrote:
Does this work for you?

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



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

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

John