Calculate using decimals?

[onmyway]

Hi guys,

I hope you can help with solving this Format and calculation issue.

All my fields in my calculation are formatted to make use of the following format: 1,00. I.e, it automatically takes a single decimal, and add the (,) comma ad 2 zeros. One can also capture a number with decimal, like 1,25

The problem is that my answer/result field .txtStockEOS1 does not calculate the decimals, only the numbers before the (,). Note: This field has not been formatted. I.e., 10 = 5,8 + 3,8 + 2,5, instead of the answer being 12,1

Here is my code that calculates on Change event:

Please Login or Register  to view this content.

Thank you all!

[MrShorty]

I'm not sure why it would, but it suggests that it is treating each addend as an integer rather than a double. One would probably need to see this in the larger context, but the first thing I would check would be the data types of the variables and make sure they are double and not integer or long.

[onmyway]

Hi MrShorty,

There are no declared variables.

I simply have textBoxes that triggers the calculation each time a change occurs in one of the text boxes.

Unless you are perhaps refering to this code used for formatting my textBoxes:

Please Login or Register  to view this content.

Is there a way I can declare each of these fields as a Double?

Something like:

Please Login or Register  to view this content.

Thank you!

[:) Sixthsense :)]

Store the Textbox values in variable and run the code in break mode and see the locals window about how the textbox values storing in variables

[onmyway]

Ah!

Something like:

Please Login or Register  to view this content.

Would I put that in my Private Sub txtStockSOS1_Exit event?

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[onmyway]

Hi Sixthsense,

Thanks for your help. I have done the following, and it seems to work. Perhaps you can give me your thoughts?

I Public declared the following:

Please Login or Register  to view this content.

I then included my _Change() event in my _Exit event, thus combining my calculation and field formatting:

Please Login or Register  to view this content.

This calculates my value with every field exit, and it does update my answer/value field with a Double value - number and decimal.

One question:

I have tried adding the following line of code beneath my calculation (where I put the * above):

Please Login or Register  to view this content.

But it changes the value from 2,5 to 0,13 for instance?

[onmyway]

So, in other words; how can I declare or format my answer field as Numeric, with the following format #,##0.00 ?

[onmyway]

Hi all,

i got it working. Here is my code:

Please Login or Register  to view this content.

Please feel free to give me your input regarding my method, and possible better solutions and methods.

Be blessed!