Excel VBA - Interest Calculation with Penalty payment

Dear Friends,

I have a problem with some vba code. Our company is providing loan facilities to customers. The company have been recordings all details based on manual system. Recently I joined in this company. Now I just use excel to save my time. But I couldn't solve this issues, please help me to solve this my issues. I attached my file herewith.

Please response me early as possible.

Advance Thanks!!

Loan Card Settlement-1.xlsm

You have more than 4 codes in module. I run your code and did not any error, but it does not necessarily mean the code is working as you had intended. You need to explain what is the problem with the code? Which part of the code you want help?

I noted my problem in the excel sheet in a text box. Thanks AB33