Cancel above i just used the listbox row source seems to be happy with that (i hope) thank you for all your time and help im crap at vba so may come back to you should i get stuck again