Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox with 2 Columns
Hi
I have a listbox in my userform in which i would like to have two columns show up from my find result. I am mixed as to the coding of which i have the extract below. Thks Kz With grSearchRng Set C = .Find(gvFindX, , goLookIn, goLookAt, goSearchOrder, , gbMatchCase) If Not C Is Nothing Then sFirstAddr = C.Address Do ufFind.LstFound.AddItem "'" & C.Worksheet.Name & "'!" & C.Address If IsNumeric(C.Value) Then Select Case C.Column Case 9, 10 error here-- ufFind.LstFound.List(.ListCount - 1, 1) = C.Value Case Else ufFind.LstFound.List(.ListCount - 1, 1) = Format(C.Value, "#,##0.00") End Select Else ufFind.LstFound.List(.LstFound.ListCount - 1, 1) = C.Value End If Set C = .FindNext(C) Loop While Not C Is Nothing And C.Address < sFirstAddr End If End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox with 2 Columns
Kieranz explained on 9/9/2011 :
Hi I have a listbox in my userform in which i would like to have two columns show up from my find result. I am mixed as to the coding of which i have the extract below. Thks Kz With grSearchRng Set C = .Find(gvFindX, , goLookIn, goLookAt, goSearchOrder, , gbMatchCase) If Not C Is Nothing Then sFirstAddr = C.Address Do ufFind.LstFound.AddItem "'" & C.Worksheet.Name & "'!" & C.Address If IsNumeric(C.Value) Then Select Case C.Column Case 9, 10 error here-- ufFind.LstFound.List(.ListCount - 1, 1) = C.Value Case Else ufFind.LstFound.List(.ListCount - 1, 1) = Format(C.Value, "#,##0.00") End Select Else ufFind.LstFound.List(.LstFound.ListCount - 1, 1) = C.Value End If Set C = .FindNext(C) Loop While Not C Is Nothing And C.Address < sFirstAddr End If End With I suggest using an array to collect your data, THEN populate the listbox from the array as this would be the quickest way. You also need to set the ColumnCount property for the number of cols. To add individual items you need to use the row/col index like this... ListBox1.List(0, 0) = <col1 data ListBox1.List(0, 1) = <col2 data To 'dump' a 2D array into the listbox in one step... ListBox1.List = myArray -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox with 2 Columns
Hi Gerry. Many thks for your reply. Being a newbie and lost on arrays
though i am reading about them How do i dim the arrays and then apply to populate the listbox with 2 col. Thks K Ps did not have internet connection. I suggest using an array to collect your data, THEN populate the listbox from the array as this would be the quickest way. You also need to set the ColumnCount property for the number of cols. To add individual items you need to use the row/col index like this... * ListBox1.List(0, 0) = <col1 data * ListBox1.List(0, 1) = <col2 data To 'dump' a 2D array into the listbox in one step... * ListBox1.List = myArray -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox with 2 Columns
Kieranz was thinking very hard :
How do i dim the arrays and then apply to populate the listbox with 2 col. You'll need to provide more detailed info about your search process in order for me to draft you a sample to run with. Define usage for: grSearchRng gvFindX goLookIn goLookAt goSearchOrder ufFind ufFind.LstFound -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I freeze columns in a listbox | Excel Programming | |||
Can't added two columns from one listbox to two columns in another | Excel Programming | |||
Formating listbox columns | Excel Programming | |||
format listbox columns | Excel Programming | |||
Listbox Max Columns | Excel Programming |