Sum values of column 5 of listbox1

[LaDdIe]

Hiya.

On UserForm1 I have;
A listbox1 with 5 columns, and a TextBox1
There are 200 Items in the list, added at run time.

If ListBox1 Column 4 shows "CTR" I need TextBox1 to show the sum of Column 5.

Any solutions please..

 

[JLGWhiz]

See if this site helps:

http://www.tek-tips.com/viewthread.cfm?qid=1470910&page=1

 

[LaDdIe]

Thanks, I gots some Ideas that helped.

See if this site helps:

http://www.tek-tips.com/viewthread.cfm?qid=1470910&page=1