Change Textbox Value automatically upon data entered

Hi all,

I have the following code that places the values from text boxes in a excel form, but it doesn't automatically change unless I click inside the textbox itself, is there a way for it to automatically change depending on the data entered?

Private Sub FinalDonations_Change()
FinalDonations.Text = Val(Donation.Text) + Val(TotalTextBox.Text)
End Sub

Thanks in advance.

That is because the change event does not happen unless you enter the FinalDonations text box.
As you are not entering anything place the statement in either the Donation textbox or TotalTextBox which ever is the last to be updated with data entered.

Thanks for your explanation, no matter what I try nothing happens, this is my full code (I've changed some of the text boxes to make it easier for us to understand)..

Private Sub DonationAmount_AfterUpdate()
MonthsBox.Value = DateDiff("m", CDate(StartDate.Value), CDate(TodaysDate.Value))
End Sub

Private Sub TotalTextBox_AfterUpdate()
TotalTextBox.Text = Val(MonthsBox.Text) * Val(DonationAmount.Text)
End Sub

Private Sub FinalDonations_Change()
FinalDonations.Text = Val(CashDonations.Text) + Val(TotalTextBox.Text)
End Sub

MonthsBox displays how many months the person has donated.
TotalTextBox displays the final calculation amount by how many months, times the donation amount (we have two which I select from a drop down combobox)
FinalDonation adds the CashDonation amount and the TotalTextBox together to show how much a person has donated to our charity.

All works, just a pain keep placing a number in the FinalDonations to show the final amount.

The main places I will edit are the donation amount and the cash. Any help would be grateful.

far easier to give a concise solution with a copy of the workbook.
see big yellow banner - how to upload a workbook.
replace the data with a dozen rows of de-sensitised data - as long as the structure and any formatting/formula are in place.
torachan.

Thank you, I've attached the form (updated the names, I was getting myself confused - which is very easy lol)

Sorry, have been busy, however looked through your form, not 100% understanding the period logic.
My approach is always not to have any formula within the data storage area, it takes too much maintaining and very often causes conflicts, especially if there are masses of calculations every time a value is changed, so I control and restrict everything to code.
For presentation and structure tables are the best method of data storage, they are virtually self maintaining, you do not have to bother with range sizes and alterations.
I have used table referencing on the 'cells' on the 'Start' sheet - you will see from these that there is no need to maintain (i.e. no need to expand your range references).
Also within the code there is no need to constantly 'lookup' data - once the 'user combobox' is loaded with the data array you can refer to it in memory instead of constantly reading the sheet - the larger the app the quicker this method is - similarly if you have all your textboxes set in the order of you data store you can loop through them instead of referencing each individually by name - again the bigger the app the greater the saving on code.
Any queries post back on this site - I will do my best to explain.
torachan.

WOW Thank you so much, looks great I'm still learning VBA but this is a next level. Amazing thank you.

thanks for the feed-back.
glad to help.
torachan.