Private Sub TextBox2_Change()
countit
End Sub
Private Sub TextBox3_Change()
countit
End Sub
Sub countit()
TextBox1 = Val(TextBox2) - Val(TextBox3)
End Sub
<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