Total for multiselection in list box on userform.

**excelkeechak** · 03-21-2012, 09:08 AM

i had a list box on the userform with columns in it.i want the total of the TURNOVER to be displayed dynamically in a text box on the same userform when a selection/multiselection is made in the list box.

I had attached the sample file...pls tell me is it possible.?

**jaslake** · 03-21-2012, 11:02 AM

Hi excelkeechak
Here's one way

Please Login or Register  to view this content.

**jaslake** · 03-21-2012, 11:24 AM

Hi excelkeechak
And here's another way

Please Login or Register  to view this content.

**excelkeechak** · 03-22-2012, 03:15 AM

Thanks jasalake for the code.The two codes work greatly.i choose to use the second one.

**jaslake** · 03-22-2012, 10:37 AM

You're welcome...glad I could be of help. If that satisfies your need, I'd appreciate it if you'll please mark your thread as "Solved".

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solved
- Click Save