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