Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the Exit Event of each textbox put in the code
rivate Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) Textbox4.Text = Format(clng(textbox1) + clng(textbox2) + clng(textbox3),"0") End Sub Repeat for Textbox2 and Textbox3 You can also use the afterupdate event. Change clng to csng if the numbers will be decimals/fractions. -- Regards, Tom Ogilvy "Gary Phillips" wrote in message ... I've got four textboxes... The first three are enabled, the fourth is not. I want the user to be able to enter an integer value into the first three and it will add those three values into the fourth box. I do not want the user to have to press any buttons, I want it to update as the user goes along. How can I do this? Thanks, Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Axes values changes autmatically / textboxes lose formatting | Charts and Charting in Excel | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Adding values in textboxes... | Excel Programming | |||
Adding the values of 2 textboxes | Excel Programming | |||
Add values of textboxes together | Excel Programming |