ExcelBanter - Sum values of column 5 of listbox1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sum values of column 5 of listbox1 (https://www.excelbanter.com/excel-programming/422634-sum-values-column-5-listbox1.html)

LaDdIe

Sum values of column 5 of listbox1

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

Sum values of column 5 of listbox1

See if this site helps:

http://www.tek-tips.com/viewthread.c...1470910&page=1

"LaDdIe" wrote:

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..

LaDdIe

Sum values of column 5 of listbox1

Thanks, I gots some Ideas that helped.

"JLGWhiz" wrote:

See if this site helps:

http://www.tek-tips.com/viewthread.c...1470910&page=1

"LaDdIe" wrote:

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..

All times are GMT +1. The time now is 02:58 AM.