In the General Declarations section I have...
To fill the listboxes I do...Code:Dim secondvalue(100) Dim thirdvalue(100)
To perform the calculations I get the numbers by doing...Code:For x = 1 To 10 z = Format(x, "##,##0.00#") listsecond.AddItem z Next x For x = 1.0 To 10 Step 0.01 z = Format(x, "##,##0.00#") listthird.AddItem z Next x
And then I do the calculations...Code:secondvalue(1) = listsecond.List(listsecond.ListIndex) thirdvalue(1) = listthird.List(listthird.ListIndex)
Thanks for the reply.Code:x = secondvalue(1) * (thirdvalue(1) / 100) y = x / 365 amountvalue = y / 86400




Reply With Quote