- Joined
- Dec 18, 2006
- Messages
- 2
- Reaction score
- 0
Hi there, I'm a new comer and would like to get help from you guys expertise.
I have been trying to fit data through variables into a listbox. What 's been done is :
- scan through all rows on a sheet with specified test criteria
- assign content to the variables from the same row of the matched value
- dump the variables value into a listbox
Since I can't figure the multi column listbox out, the usual single is used as below :
For n = 0 To j - 1
usfOption.lstOption.AddItem n + 1 & ". " & MappedPoint & _
" " & D(n) & " " & A(n) & " " & ACT(n) & " " & DOW(n)
Next n
since the length of the text is not the same, the output is awkward !
Actually I know how many columns I need while the row count should be variable.
Can anyone help ?
Regards,
cc
I have been trying to fit data through variables into a listbox. What 's been done is :
- scan through all rows on a sheet with specified test criteria
- assign content to the variables from the same row of the matched value
- dump the variables value into a listbox
Since I can't figure the multi column listbox out, the usual single is used as below :
For n = 0 To j - 1
usfOption.lstOption.AddItem n + 1 & ". " & MappedPoint & _
" " & D(n) & " " & A(n) & " " & ACT(n) & " " & DOW(n)
Next n
since the length of the text is not the same, the output is awkward !
Actually I know how many columns I need while the row count should be variable.
Can anyone help ?
Regards,
cc