Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing the values in text boxes
I am working with a user form that has three text boxes. The text boxe are connected to three scroll bars. When the user adjusts the scrol bars, the text box values change accordingly, or the user can manuall enter a value into each box. I would like to have a fourth text box that is a sum of the previou three. I've tried a few things, but with no luck. As the user change each box, the total in the fourth box should adjust accordingly. Does anyone have any ideas on how to get this to work? I've trie this... txt4 = txt1.value + txt2.value + txt3.value Thank -- cosmic m ----------------------------------------------------------------------- cosmic mo's Profile: http://www.excelforum.com/member.php...fo&userid=2090 View this thread: http://www.excelforum.com/showthread.php?threadid=52333 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing the values in text boxes
Generally speaking that should work, but you need to run that code when any
of the textboxes change... Another thing to try would be to convert the values to numbers (text boxes hold text strings)... txt4 = cdbl(txt1.value) + cdbl(txt2.value) + cdbl(txt3.value) -- HTH... Jim Thomlinson "cosmic mo" wrote: I am working with a user form that has three text boxes. The text boxes are connected to three scroll bars. When the user adjusts the scroll bars, the text box values change accordingly, or the user can manually enter a value into each box. I would like to have a fourth text box that is a sum of the previous three. I've tried a few things, but with no luck. As the user changes each box, the total in the fourth box should adjust accordingly. Does anyone have any ideas on how to get this to work? I've tried this... txt4 = txt1.value + txt2.value + txt3.value Thanks -- cosmic mo ------------------------------------------------------------------------ cosmic mo's Profile: http://www.excelforum.com/member.php...o&userid=20900 View this thread: http://www.excelforum.com/showthread...hreadid=523339 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing the values in text boxes
Hi Cosmic mo
Could you teach me please how you setup the connection between a textbox and a scroll bar such that when the user adjusts the scroll bar, the textbox immediately changes - even before the user lifts their finger off the mouse. Thanks Phil "cosmic mo" wrote: I am working with a user form that has three text boxes. The text boxes are connected to three scroll bars. When the user adjusts the scroll bars, the text box values change accordingly, or the user can manually enter a value into each box. I would like to have a fourth text box that is a sum of the previous three. I've tried a few things, but with no luck. As the user changes each box, the total in the fourth box should adjust accordingly. Does anyone have any ideas on how to get this to work? I've tried this... txt4 = txt1.value + txt2.value + txt3.value Thanks -- cosmic mo ------------------------------------------------------------------------ cosmic mo's Profile: http://www.excelforum.com/member.php...o&userid=20900 View this thread: http://www.excelforum.com/showthread...hreadid=523339 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing the values in text boxes
Hi Phil, Here is the code I used for one scroll bar. There are two separate subs I wrote for each scroll bar on my form. This one will change the values when the user clicks the scroll bar arrows, or clicks anywhere within the bar... Private Sub scrCost_Change() txtCost = scrCost / 100 End Sub This one will change the value when the user drags the scroll bar... Private Sub scrCost_Scroll() txtCost = scrCost / 100 End Sub The only difference is the _Change and the _Scroll portion. Hopefully that helps. Phil1982 Wrote: Hi Cosmic mo Could you teach me please how you setup the connection between a textbox and a scroll bar such that when the user adjusts the scroll bar, the textbox immediately changes - even before the user lifts their finger off the mouse. Thanks Phil -- cosmic mo ------------------------------------------------------------------------ cosmic mo's Profile: http://www.excelforum.com/member.php...o&userid=20900 View this thread: http://www.excelforum.com/showthread...hreadid=523339 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing the values in text boxes
Thanks for the suggestion, Jim. It turns out there was a separate erro causing my problems. I love it when that happens... Morgan Jim Thomlinson Wrote: Generally speaking that should work, but you need to run that code whe any of the textboxes change... Another thing to try would be to conver the values to numbers (text boxes hold text strings)... txt4 = cdbl(txt1.value) + cdbl(txt2.value) + cdbl(txt3.value) -- HTH... Jim Thomlinso -- cosmic m ----------------------------------------------------------------------- cosmic mo's Profile: http://www.excelforum.com/member.php...fo&userid=2090 View this thread: http://www.excelforum.com/showthread.php?threadid=52333 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Data labels switch to text boxes on negative values | Charts and Charting in Excel | |||
Summing values in a range against specific text | Excel Discussion (Misc queries) | |||
Setting Property Values of Text Boxes within Forms | Excel Programming | |||
How do you search values and display them in lables/text boxes | Excel Programming |