Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
put worksheet values into textbox on form
I have a form that I'm using to get values to put into various worksheets. On some of the forms I'd like to in turn get some calculated values from the worksheets and display them in a textbox. I haven't been able to figure out how to do this. It seems like it should be simple. I can go in the other direction, putting the textbox values from the form into the worksheets. Thanks -- thmort ------------------------------------------------------------------------ thmort's Profile: http://www.excelforum.com/member.php...o&userid=25296 View this thread: http://www.excelforum.com/showthread...hreadid=387819 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
put worksheet values into textbox on form
The way that I use is to name the cell (Highlight the cell of
interest, go to the menu bar and choose InsertNameDefine. Call the cell anything - no spaces!). In your UserForm, when you want the cell contents to appear, place something like: TextBox.Value = Range("NamedCell").Value Hope this helps. -Minitman On Sun, 17 Jul 2005 02:34:17 -0500, thmort wrote: I have a form that I'm using to get values to put into various worksheets. On some of the forms I'd like to in turn get some calculated values from the worksheets and display them in a textbox. I haven't been able to figure out how to do this. It seems like it should be simple. I can go in the other direction, putting the textbox values from the form into the worksheets. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
put worksheet values into textbox on form
TextBox1.Text = Worksheets("Sheet2").Range("A1").Value
-- HTH Bob Phillips "thmort" wrote in message ... I have a form that I'm using to get values to put into various worksheets. On some of the forms I'd like to in turn get some calculated values from the worksheets and display them in a textbox. I haven't been able to figure out how to do this. It seems like it should be simple. I can go in the other direction, putting the textbox values from the form into the worksheets. Thanks -- thmort ------------------------------------------------------------------------ thmort's Profile: http://www.excelforum.com/member.php...o&userid=25296 View this thread: http://www.excelforum.com/showthread...hreadid=387819 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass to textbox on a form and to excel worksheet | New Users to Excel | |||
User Form in VB = TextBox | Excel Discussion (Misc queries) | |||
TextBox on a Form How do I.......? | Excel Programming | |||
textbox on form | Excel Programming | |||
Extract unique values from worksheet into form | Excel Programming |