problem show TOTAL row for each range based on selected name from combobox on form

Hello,
I would fix the code when select NAME from combobox and match with column C should show a ll of data in listbox for the name.
the code has problem , will not show TOTAL row and when show data are not arranged , also I would populate names in combobox 1 fo all of names in column C without duplicates , empty . here is the code .

Please Login or Register  to view this content.

thanks sintek .
may you guide me how show numberformat(#,##0.00) in numbers columns into listbox?

Thank you so much.