Userform

[triaz]

Hi,

I have a userform that takes user input and places it in a certai
location of a worksheet. The location of the cells is static ie th
information always goes in the exact same place.

The problem I have is, each time the userform is called it needs t
display the completed cell contents in the form, hence making it easie
for the user to:

a) edit any existing content
b) serve as a base for subsequent sheets hence saving time

I can get information from the form to the cells but not the othe
way.

Can anybody help with this?

Thanks in advance.

T

 

[bizju]

Hi,
assuming your data is in cell A1, you could try this

Private Sub UserForm_Initialize()
TextBox1 = Range("a1")
End Sub

regards,
julian