• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

CALCULATION ON USER FORM

Hi to everyone

I am working on a project and i want a caculation on a userform in such a way that the answer show dirctly on then form without a button click.

I have a userfom in an excel file.There are five text boxes.The first box is for Inv amount,the second box is for WHT rate (the value is in % i.e 5%),the 3rd Text box is for WHT amount, the 4th tex box is for deduction and in the last text box i want the net amount caculated dirctly.
Please let me guide by any experience person.I have attached the file. Thanks

myform.jpg





















cB77Bx
 

Attachments

  • My Calculation.xlsm
    20 KB · Views: 1
Last edited:
Your user form in your worksheet does not reflect what you have shown in your thread. You have five text boxes in you picture, but your workbook form only has 4 textboxes. Which is correct and please ensure that you update the correct form in your worksheet so that we can give you a viable solution.
 
Back
Top