hi, everyone
i am using combobox1.value to pass out data to sheets("OF BC").
i want , If combobox1.value match data from sheets("OL BC"), then data of column "H" show in listbox
like
combobox1.value = "anees g" then search on SHEETS("OL BC") IN RANGE("C4:C10"), If value found then show data in listbox of column H
combobox1.value = "anees g" then lisbox1.value = "11 BC DDD"
thanx
sample attached
Bookmarks