MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I Need Help With Calling A Function

Posted by Faye Montgomery on November 02, 2001 4:50 AM

Good day to all,

I have 2 textboxes on a form which will contain numbers what I want to do is add numbers together and the result will be shown in textbox3 which is the last control on the form. Can anyone tell me how I can get the code to be executed after I have entered the data in textbox2.



Posted by Juan Pablo on November 02, 2001 4:53 AM

Use something like

Private Sub TextBox2_Change()
TextBox3 = TextBox1 + TextBox2
End Sub

Juan Pablo