Get statistical results in text boxes of userform.

[MariaPap]

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.

[Tinbendr]

May need some fine tuning.

[MariaPap]

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.

[Tinbendr]

Try to change the ChargeDate declaration to a string.

Please Login or Register  to view this content.

[MariaPap]

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

Take a look to the video pls!

http://screencast.com/t/pwld0zqR

[Tinbendr]

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

[MariaPap]

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?

[Tinbendr]

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

[Tinbendr]

Here's an link that looks promising.

[Fotis1991]

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!

[MariaPap]

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!!

[Fotis1991]

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