Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New to User Forms | New Users to Excel | |||
User Forms | New Users to Excel | |||
user forms | Excel Discussion (Misc queries) | |||
User forms in VBA | Excel Programming | |||
User forms | Excel Programming |