find value in sheet based on combobox and show in listbox

[herukuncahyono]

hi,
I have a userform that allows me to search for a specific value and displays it.
I find the code, but only to seek the active sheet ( only sheet 1 data) ,Can help me create a code for that function.

thanks in advance
herukuncahyono

[sweep]

Hi,

Please see attached file.

[herukuncahyono]

hi sweep,
Thanks for quick response & share knowledge.
one of my problem solved
thanks for "sweep" my problem

regards
herukuncahyono