UserForm Textbox Sum Help

**calvinle** · 05-23-2014, 12:01 PM

Hi,

I want to know if its possible for the TextBox3 to automatically SUM the TextBox1 and TextBox2, without having to go on it and press 0.

Here is the sample:
UserformTest.xlsm

Help anyone?

Thanks.

**HaHoBe** · 05-23-2014, 12:08 PM

Hi, calvinle,

maybe just like this:

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

Maybe I´d go with the Exit-Event instaed of the Change.

Ciao,
Holger

**calvinle** · 05-23-2014, 12:28 PM

Genius! But what should be the code for the Exit Event?

Thanks.

**HaHoBe** · 05-23-2014, 12:32 PM

Hi, calvinle,

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox3 = Val(TextBox1) + Val(TextBox2)
End Sub

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox3 = Val(TextBox1) + Val(TextBox2)
End Sub

You could close Textbox3 in order to avoid the user to click into the control.

Ciao,
Holger

UserForm Textbox Sum Help

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

UserForm Textbox Sum Help

Re: UserForm Textbox Sum Help

Re: UserForm Textbox Sum Help

Re: UserForm Textbox Sum Help

Thread Information

Users Browsing this Thread

Similar Threads

Using a userform textbox on clicking OK write the data to a textbox on the worksheet NOT

Userform to search textbox value to place other textbox values in worksheet

[SOLVED] Excel Userform TextBox - Change partial string in textbox with command button

Userform Textbox updating a another userform textbox (im stuck!!)

Bookmarks

Bookmarks

Posting Permissions