Sum Values from a list box

[gropereng]

I have a listbox that is populated with data input from the user; this consists of
1, The Item name
2, The Items thickness

Is it possible once all of the items have been added to the list to Sum the total thickness?

Thanks

 

[bstory84]

Assuming this is 1 listbox and it is 2 columns wide. and all the integer values are in column 2.
then put this into whichever action sub to calculate the sum.
NOTE: Change textbox1 to whatever textbox you want to populate with the total. also need to Change listbox1 to whatever the name is of your current listbox.

TextBox1 = WorksheetFunction.Sum(ListBox1.List)