View Full Version : Access the values of a value list listbox


patrickd123
04-03-2007, 07:29 AM
Hi,

I have a list box for wich the the source is a value list. I am not seeing any property that can give me the selected values. The only property I see that ressembles is th source properties which consist of a string with all values concatenated and separated by semi columns, which is not practical if I want to access a value in the middle of the list. I had hoped that there had been a property that contained an array of the value that I could have accessed with the proper index.

Any idea?

Thanks

pbaldy
04-03-2007, 07:41 AM
Search here on multiselect, which should turn up the code to loop through the selected values.

MicroE
04-03-2007, 07:53 AM
Check out - Multi-Select Listbox Functions (http://www.myaccesstips.com/Functionality/MultiSelect.html)

patrickd123
04-03-2007, 11:03 AM
Wow!!!!! Way more that I was hoping for! Thanks

I really like this forum and I hope that one day I will be able to help as much as I have been helped over here!!! (I am kind of a guru in SAP, but, as you can see, a nulity in VBA)!!!