VBA code to auto update a field based on 2 fields

[prabhu04]

Dear all,

I am creating a custom billing tool using excel & VBA.

I am new to VBA advance codes like private sub and so..

I have created a form. It has 2 variables.

One is the amount and other is the gst %.

Once i update / change the values in the amount or gst section, the total amount should be updated automatically.

I have a code which updates the total amount based on changes in the gst section.

If I change the amount section, the total amount is not updating accordingly.

Attaching the file for reference.

Seeking your help to get a code which updates the total based on any change in either amount or gst.


Thanks in advance..!!


**** EDIT ****

In my attached file, if we click the Button 1, one user form will open.

In that, if we input the values in the box corresponding to AMT and GST%, the total will be calculated and displayed in the corresponding box.

Now, if we are changing the AMT content means, the total value is not calculating.
In this case, i am reentering the GST% value to auto calculate the total.

Meanwhile, whenever i am changing the GST% content, the total value changes automatically.

My need is, the total value needs to be auto calculated and displayed whenever i am making changes to either AMT or GST%.

[Logit]

.
Here is a sample database Userform. Study the code and apply to your project.

Please Login or Register  to view this content.

[prabhu04]

Hai Logit,

thank you for the quick update.

But i hope the code you sent is different from my need or somewhere I am lagging to understand yours..!!


In my attached file, if we click the Button 1, one user form will open.

In that, if we input the values in the box corresponding to AMT and GST%, the total will be calculated and displayed in the corresponding box.

Now, if i am changing the AMT content means, the total value is not calculating.
Meanwhile, whenever i am changing the GST% content, the total value changes automatically.

My need is, the total value needs to be auto calculated and displayed whenever i am making changes to either AMT or GST%.

[Logit]

.

Please Login or Register  to view this content.

[prabhu04]

Thank you Logit.....

This works....

[Logit]

.
You are welcome.