Programatically Selecting all values in listbox

[pcdaveh]

Is there a way to Programatically select all values in a list box? I have a list box that when I run a report I want it to select all the values every item in the list box and then dump those values into a table. I have the code to get it into the table. I just need to know how to select all the values.

 

[jebry]

Hi!

Try this:

Dim lngRowCount As Long

For lngRowCount = 0 To YourListBox.ItemCount - 1
YourListBox(lngRowCount).Selected = True
Next lngRowCount

hth
Jeff Bridgham
bridgham@purdue.edu