Get statistical results in text boxes of userform.

Hello

My goal is this.

When the user choose a customer from a combo box then i need to get some statistical results in the text boxes, such as last amount of credit-charge, last date, and amount that he has to pay us until now.
When user adds a new amount in the grey textbox then this has to be added in the previous amount.

I have the expected results of my example in my sample sheet.

Thanks in advance for any help.

May need some fine tuning.

Hello

This works great. Thank you!

Now my problem is that i try to add this code with another one that you offered to me in another thread a few days ago and i get an Error "Can't find a project or library and highlight the red part of the code!

Can you pls take a look on this?

Please Login or Register  to view this content.

Try to change the ChargeDate declaration to a string.

Please Login or Register  to view this content.

Thanks for your reply. Unfortunately this does not helps. Same error!

Take a look to the video pls!

http://screencast.com/t/pwld0zqR

I don't get that error. Make sure the reference are set.
Error.jpg

The reference is checked as you show me in your pic.

Must be something in the combination of the 2 different codes but i am not able to find what happens ...

Did you open my attachment(post#3) and everything works for you?

Yes. I purposely d/l your attachment, but did not get error. I watched your screen grab and selected the same as you. Strange!???

Here's an link that looks promising.

Maria try with this highlighted red part of the code and tell us what happens.

....

Please Login or Register  to view this content.

Note: Changing of course the

Please Login or Register  to view this content.

as Tinbendr suggested!

Originally Posted by Fotis1991

Maria try with this highlighted red part of the code and tell us what happens.
Note: Changing of course the

Please Login or Register  to view this content.

as Tinbendr suggested!

What happens? The same as every time that you suggest something Mr Foti!! Works like a charm!!!

Many thanks to both of you!!

Tinbendr is the one that deserves the thanks. Nice work!