It's great Toopers
Thanks a lot

One more thing ... How can I put name instead of number

(eg Material A is the bigest)

cc

"Toppers" wrote:

sorry ..... put

msgbox application.max(calc1,calc2) & "is the biggest!"


"CC" wrote:

Hi Toopers

I have this error msg


"Sub or Function not defined"

CC



"Toppers" wrote:

msgbox max(calc1,calc2) & "is the biggest!"

where calc1=material A 2000 litrs * dens 1.3 = 2600 kg
calc2=material B 1000 litrs * dens 1.3 = 1300 kg

HTH

"CC" wrote:

Gentle people


I'm a beginner... real beginner .. and I have this problem
I have two inpuBox with two questions about the amount of materials ( eg.
amount of Material A and Amount of Material B)
then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg
and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a
Msgbox show the bigest

Can you hlp ?