Realtime sums on a user form.

[Matt0110]

Sorry - sorted it out.

Me.TextBo1.Value = TextBox3.Value - TextBox2.Value

 

[erik.van.geit]

Hi, Matt,

to get you started:
In the Userform code, you can put something like this.

Private Sub TextBox2_Change()
countit
End Sub

Private Sub TextBox3_Change()
countit
End Sub
 
Sub countit()
TextBox1 = Val(TextBox2) - Val(TextBox3)
End Sub

kind regards,
Erik

 

[erik.van.geit]

you may have sorted out your problem
but now your edited post doesn't make much sense anymore

you could have left the question and add your reponse
here is the initial post

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->
Hi all,

I'm struggling to find some way of capturing what i want.

I have 3 textboxes on a userform (textbox 1,2 and 3). When the user changes textbox 3 i want textbox1 to equal the value of textbox 3 minus textbox 2.

I hope that makes sense?

Cheers,

Matt

by the way, your code has a typo and will bug when on box is still empty

 

[Matt0110]

Of course - sorry!

Thanks for your help Erik and to everyone else who uses this board. It really is invaluable!

Cheers,

 

[Matt0110]

Of course - sorry!

Thanks for your help Erik and to everyone else who uses this board. It really is invaluable!

Cheers,