what I would like to have happen is when I enter a value into textbox1 of the userform it looks in "sheet2" for the column that matches the textbox value and populates listbox1 with the values from that column... thank you!