Hi

I am trying to get a value in one of my worksheets to
display in a created userform. Basically I have created a
working spreadsheet that includes very longwinded and
tedious equations (all of which give the correct
solutions). Rather than rewriting the whole thing into
visual basic (or similar)I thought I would cheat and
simply produce some userforms that place data in cells and
collect from other cells. Thus there is no need to
recreate the equations

strspeed = TextBox2.Value
Range("'(1) Design characteristics'!B6").Value =
strspeed

I have managed to send data to the sheet from the user
form using the above code (when a command button is
pressed) but have been unable to get values from the
worksheets to the userform - can anybody help?? I have
been trying to get the text back into a textbox.

I am using office (excel) 2000 - Cheers