Hi,
I have names in a range ("A2:A200") in Sheet1. I also have numbers in a range ("B2:DP200") in the same Sheet1. Only 1 number correspondences to each name in the range depending on the date and some names have the same number. In my Userform1 I have a combobox2 with all the numbers in the range. I have set up a listbox2 on the userform1 and I need to click a command button and bring up the names in the listbox2 relating to the value showing in combobox2. Can anyone help with a code?

Regards,
PyroForm (Tony)