ListBox Userform (Sum, total and calculating)

[calvinle]

Hi guys,

I am stuck with this listbox to calculate the total as per the amount entered in a combobox1.

1) I want the result to be listed in the 3rd column of the listbox.
2) If the total in the listbox does not match with the combobox, because of the rounding problem, then the difference will be added to the 1st row of the listbox.

Here is the sample that I was stuck in:
calculate.xlsm

Hope anyone can help.

Thanks.

[Bob Phillips]

Change the definition of the named range test to A1:C9, and try

Please Login or Register  to view this content.

[calvinle]

Hi,

For this sample, I use a define name for it. However, the combobox populate the listing from a mastersheet containing a lot of data. I cannot set the range to active sheet.

Is there a way to get the amount directly from listbox and calculate from there??

[Bob Phillips]

No, because you bound the object, you have to work on the range.

[calvinle]

Then will it be possible to not list them in the listbox but have show the result in a message box instead? I did it for the last row but i dont have any clue to show for each available row.

[calvinle]

Ohh i figure it out... Instead of using the same listbox, i added a new listbox right beside so i have all new data to control it. Then some manipulation with variable and i got to it.