Button to calculate multiple math operations in a userform, at once

**Alex Piotto** · 03-25-2018, 02:02 PM

Hi good people,
I have a userform that gets some data (numbers) from a database sheet when initialize. Good. It works.
I put there a command button to launch the calculation inside the userform.
It works too, BUT I have to click the button several time to complete all the calculations.

Why? And how can avoid it? I would like to click once on the calculate button and have all the calculations done. In one click.

Here the code of the buttons. Remember, it works but require several click to complete:

Please Login or Register  to view this content.

It is not really important where the data came from or is going... I just, need to learn how to calculate the operations in red with one click!

**AlphaFrog** · 03-25-2018, 11:31 PM

I don't know the nature of your data, but it looks like you are calculating values with decimals. The variables you declare are type Long which are large integers. Perhaps if you declared them as Double e.g.;

Please Login or Register  to view this content.

**Alex Piotto** · 03-26-2018, 01:19 AM

Hi AlphaFrog, thank for answer me.

I changed the "long" with the "double". Thanks for the tip. (but i swear it was working anyway!)

Unfortunately the button must be clicked 3 times anyway to calculate all.....

It is like the code calculates the first 6 (red) lines at once, than the 7th, than the last.
I think it is due to the fact that the first 6 lines calculate values that immediately appear in the form (i can see some of the calculations done at first click).
Than it is needed a second click for line 7, that create the value "adescfaltas" and put in the form. (i can see it too).

Then, the 3d click is for the last line. So it is like i will have to run the macro 3 times... I wonder how....

Or, maybe, do all the calculation before writing in the form... with some hidden textbox for example... but i do not like the idea...

**bakerman2** · 03-26-2018, 01:44 AM

This shouldn't normally b any problem. Can you post example file with your userform in it ?

**Alex Piotto** · 03-26-2018, 01:52 AM

Hi bakerman2, i will do it later after work...

**xlnitwit** · 03-26-2018, 03:19 AM

At a guess your issue is the order of your code

Please Login or Register  to view this content.

the highlighted lines show that you assign the value of the TAXAHORA control to the ataxahora variable, then your code changes the value of the control but never updates the variable before using the variable in the third highlighted line. I presume that was not what you needed.

**Alex Piotto** · 03-26-2018, 03:35 AM

Hi, got an unexpected shift change at work... good for the coding!

I made up an example file.
The database contains lots of columns but i only retrieve data from some of them, the ones needed for calculation.
Open the file. Click on the name Alex Piotto (the only name i left there for testing purposes. Data is fake).

The form will pop up with some values already in place, others will be zeros.

As it is, click CALCULAR, one, two, three times, until the TOTAL do not changes anymore.

You can change the values of the green labeled textboxes in order to test if the math is OK.

What do you think? It is an order problem, as xlnitwit suggests?

**bakerman2** · 03-26-2018, 05:10 AM

Think I figured it out.

Please Login or Register  to view this content.

**Alex Piotto** · 03-26-2018, 05:11 AM

Until now I managed to BRUTALLY call the function 3 times... now it calculates all in one click. But surely exists a better way!

Please Login or Register  to view this content.

**bakerman2** · 03-26-2018, 05:35 AM

Did you try my code from Post#8 ?

**Alex Piotto** · 03-26-2018, 05:40 AM

Sorry i posted mine but yours was not there yet. I will try right now!

Tested and it is working. Thank you all for the help.

**bakerman2** · 03-26-2018, 05:56 AM

Glad to help and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Button to calculate multiple math operations in a userform, at once

LinkBack

Thread Tools

Rate This Thread

Display

Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Re: Button to calculate multiple math operations in a userform, at once

Thread Information

Users Browsing this Thread

Similar Threads

Excel Case/else structure math operations.

[SOLVED] Math operations with data from LabVIEW in .TXT

Excel Case/else structure math operations.

math operations

Applying math operations on time values

how to report a value using IF function without performing any math operations

Excel 2007 : math operations with text

Bookmarks

Bookmarks

Posting Permissions