Hidden problem with a formula of the VBE

[glpx]

Hello everybody,

I've worked on a file who permits to exploit a database. This database includes many informations about the sizing and the weight of packagings. This informations used to calculate the palettization.

The calculations give the following results :

- Number of box / coat
- Number of coat on the pallet
- Number of box / pallet
- Height of pallet
- Weight pallet

The problem is in the pallet's weight. To calcul this, the formula is :

Weight = Nb box * weight gross (of 1 box) + 20 (Kg, Weight pallet)

When I simulate a calcul with any box, I don't have the good result, always less than the real result. But the formula is writting good.

Attachment 329104

Normally, we have to find 168 kg and not 140...
Calcul = 40 * 3.7 + 20 = 168 kg

Someone can find the error in the writting vbe ? Thanks

[patel45]

where are the wrong calculations ?

[glpx]

The wrong calculations is located in the code of the user form, in the part named "CALCULS"

[patel45]

very big help !
thank you

[glpx]

Excuse me, I don't know many things about the writing vba...