Mohammad Ishaq
Member
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
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
Attachments
Last edited: