I have made a booking confirmation system which stores each booking in a worksheet "Bookings". A macro enables you to view the history by searching for the booking reference number.

There's a seperate sheet "ConfirmationHistory" which has the following columns:

A) ReferenceID (this is the ref id from the Bookings sheet)
B) DateStamp (a date & time stamp that the confirmation was reprinted/emailed)
C) Info (displays whether confirmation was printed or e-mailed)
D) LoggedinUser (displays the user logged in who actioned the confirmation)

Now, when a booking is made, an entry will automatically be made in the "ConfirmationHistory" sheet that initial e-mail has been sent.

If the customer says they didnt get this, you may go back into the booking and print confirmation. In which case you'd then have a 2nd entry in this spreadsheet for the same reference number.

I was wondering if there was a way to select all rows from the table (a bit like an autofilter i guess) which have the selected reference number in the ref id field and then display these rows in one of these multi-select combo boxes for example?

i.e. Say I searched the ref num "111" in autofilter, it would only show the following 2 rows.

111 - 23/02/2010 12:00 - Initial Email Sent - Carl
111 - 25/02/2010 09:30 - Print Out Done - Carl

I then want these 2 rows to appear in a multi-line list box (not a drop down, the other kind) in my user form.

Hope I haven't confused anyone.
Thanks
Carl