Thanks Paul. I myself have been too busy today to delve into the depths but plan to do so over the weekend, family matters allowing! I have taken a quick look at the code and can see how the search function is operating. Being a newbie, one thing confuses me in that search button code and perhaps you'd explain. You have declared a variable "sLst as string" but I cannot see where that variable is used. Is it a case of declaring and then deciding you didn't need it or am I missing something?

I have not fully got to grips with the code you show against the select button; you've introduced me to two new functions - split and unbound. I have started to read up what they mean/do but not had time to fully take in. I need to go back to that section.

Thanks for your help. Lots to mull over and I still need to adapt to suit to what I am doing. Since I have some 24 columns of data I suspect I also need to find a way to loop through to create the listbox results without typing everyone individually.

I may have further questions when I have taken it myself to the next stage and hopefully can ask again for some guidance if needed. Thanks.