Worksheet value to user forms
 

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

RE Worksheet value to user forms
 

Puts the contents of cell A1 in sheet1 in textbox1 on the
user form:

Private Sub CommandButton1_Click()
Me.TextBox1 = ThisWorkbook.Worksheets("Sheet1").Cells(1, 1)
End Sub

-----Original Message-----
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
.

RE Worksheet value to user forms
 

Cheers Works a treat


-----Original Message-----
Puts the contents of cell A1 in sheet1 in textbox1 on the
user form:

Private Sub CommandButton1_Click()
Me.TextBox1 = ThisWorkbook.Worksheets("Sheet1").Cells(1,
1)
End Sub

-----Original Message-----
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
.

.