UserForm ListBox Populated by Summed Data in Two Columns

I have a worksheet with employees listed in Column A and their hours in Column B. I'd like to populate a 2-column userform ListBox with names from column A (minus duplicates), and then summing the values in column B using the names in the first column of the ListBox.

Let me know if that doesn't make sense and I'll attach a sample worksheet.


Thanks!!

Ok...I've attached a sample workbook.

In my UserForm, the first column of the ListBox pulls the individual employees in Column A of Sheet1. What I'm trying to do is get each employee's total hours from Column B on Sheet1 in the second column of the ListBox.

Also, I can't quite seem to get the headers on the ListBox to pick up the headers from row 1.

Norie, that works great!! Thanks so much!!

Any idea how to get the ListBox headers to populate from the first row?

Ok...so it works in the sample workbook, but it doesn't work when i move it to my actual workbook. I get Run-time error 70: Permission denied. Any idea why that would be?

Because you've set a row source, you can't have a row source and use additem

Kyle123, so what would you do instead?

Norie's code

But Norie's code isn't working in my actual workbook. It gives me the permissions error

Have I maybe set the row source somewhere else?

Then remove the rowsource from the listbox...

Ok...I see what you're saying. That fixed it. Thanks!!

Now, how do I get the column headers to show up?