Help me to get Total from userform

**ebin charles** · 06-09-2011, 05:38 PM

Hello

I am using excel userform to get report through listbox.
I am getting the report and it shows all data but I need the
Total column to show the total for the data shown above the list box.
Balance Column.

Can anyone please help me to solve this?

Advance thanks..

Regards
Charles

**davesexcel** · 06-09-2011, 07:24 PM

Try this addition to your code.

Please Login or Register  to view this content.

**MarvinP** · 06-09-2011, 07:37 PM

Hi Charles,
I made my subtotal on the Data sheet in J2 and then put a line in the code to put this number in TextBox3.
I think Dave's above will work too.
see attached for a test.

**ebin charles** · 06-09-2011, 11:37 PM

Originally Posted by MarvinP

Hi Charles,
I made my subtotal on the Data sheet in J2 and then put a line in the code to put this number in TextBox3.
I think Dave's above will work too.
see attached for a test.

Thank you Davesexcel and marvinP.
I'll go with Davesexcel code, that helps and simple.

Thank you so Much.
Regards
Charles