result auto reflect when input value changes

[crimzon]

Hello,

I need your help to sort this issue.

I have userform with three numeric text items, two take input from the user and third used to display the result.
As you can see the following snippet which will show result by pressing CommandButton1 after taking inputs from the users. Now my intentions to remove the button and to display the result automatically when user enter the values in gross.text and eprem.text. Kindly advise!

Please Login or Register  to view this content.

[Kaper]

have a closer look on gross_Change and eprem_Change procedures (if you dont have them yet - create them first. Easiest way rightclick on textbox in while in VBA editor and select show code),

[6StringJazzer]

display the result automatically when user enter the values in gross.text and eprem.text

How will you know when the user is done entering the values?

The Change event is triggered by every change, including typing one more character. How will you know when the user is done typing?

[Kaper]

I do not think it matters, moreover in number of cases it is a desired behaviour.
Once typing is finished the final results appear, and in a meanwhile - partial.

Of course, if it matters and one wants only final result, not partial, one could use gross_AfterUpdate and eprem_AfterUpdate events handlers instead of X_Change ones.
Then the updating would be done after gross and/or eprem loose focus.

[crimzon]

I do not think it matters, moreover in number of cases it is a desired behaviour.
Once typing is finished the final results appear, and in a meanwhile - partial.

Of course, if it matters and one wants only final result, not partial, one could use gross_AfterUpdate and eprem_AfterUpdate events handlers instead of X_Change ones.
Then the updating would be done after gross and/or eprem loose focus.

Thank you very much for your kind help.

Sir, if i want to put this functionality for all input textbox, checkbox on the userform, it would be very useless practice to write for textitems.
Is there any way to write a one sub for all changes occurred in textbox or checkbox?


Kindly also tell how to handle divide by zero exception in your attached macro? you only used + and x operator but when i used / (Divide) it raised exception divide by zero. kindly advise on it also.

[Kaper]

as for exception - you used sum in your example, so did I of course with division it would be wise to have something like:

Please Login or Register  to view this content.

for several controls simple way would be to move all computations and result displaying in one procedure which could be called from each event handler, like:

Please Login or Register  to view this content.

note that in gross field I used AfterUpdate event handler (so do_job is called after finished editing, while in eprem i left Change (do_job called after each change within)
I added 4 more controls just to show that all computations are done in one procedure taking into account state all controls on the form.

[crimzon]

thank you very much Sir for you precious time and help

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.