How to display text boxes.

[Bidwin]

I have a user form that's supposed to display data taken from a related worksheet. Data is moved from the worksheet to textboxes with statements similar to this: "TextBox1 = Worksheets(1).Cells(2, 7)", but I can't get the textboxes to display the data moved to them. Can anyone tell me how to do that? I can see data being moved into the textboxes when I step into the code and have my Watch window active.

Or, if there's a better way to do this please let me know.

Thanks in advance for your help,
Bidwin

 

[Bidwin]

Never mind, I figured it out.

 

[gareth]

Good I was goinf to explain how to do it