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