| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListBox1 - returns no value | Excel Programming | |||
| Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5 | Excel Programming | |||
| Help with: ListBox1.AddItem (ws.Name) | Excel Worksheet Functions | |||
| Listbox1 to Listbox2? | Excel Programming | |||
| (Worksheet)Listbox1.additem = (Form)Listbox1.value ?? | Excel Programming | |||
Hybrid Mode
