when an object is instantiated/created, the initialize event is run. That
is part of the internal code that is involved with managing the object.

The Initialize event must be placed in the module associated with the
userform.

The code he provided was an example.

Regards,
Tom Ogilvy

"Neal" wrote in message
...
Derek,

I inserted the code you provided and it is still not
working. I am using a Click Button to call up the
UserForm. How does it know to Initialize the UserForm?
Could you give an example? Thanks.

Neal


-----Original Message-----
You want to use the Initialize event for the userform.
The code would be something like this:

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

You will need to use the actual names for your textbox
and
worksheet.
-----Original Message-----
Dear VBA Experts,

I have a UserForm where I want to have a textbox
populated
with an amount in a cell. I have tried the
ControlSource
= the cell or the Value = the cell and am getting an
error
message. Assuming I have a number in cell A1, what is
the
code to have that info populate a textbox in a userform
so
that when the userform is opened, the textbox already
shows that amount? Thanks in advance.

Neal
.

.