printing row from listbox where column not null

[Bobnz]

Hi, I have a listbox that is populated via a query based on a user selection, this list box can contain up to 30 records/rows. What I want to do is select multiple rows (Multi select is on) and print them but only if certain columns/fields are not empty.

B

 

[mndrlion]

You can use the Column property to examine the contents of a column in a listbox. Like this

ListBoxName.Column(Index, Row)

Index is the zero based column number

Row is the optional zero based row number

ListBoxName.Column(1, 4) will return the value from the second column fifth row.

 

[FancyPrairie]

Here's how you would loop thru the items selected.

Dim varItem as Variant

For Each varItem In lstMyListBox.ItemsSelected
MsgBox lstMyListBox.Column(0, varItem)
Next varItem

 

[Bobnz]

Thanks for the replies, lollipop to FancyPrairie.

B