Show unique values in listbox and activate related cell if i select value in Listbox

hi,
i am populating my listbox to show unique values of sheets("sheet1").Range("f10:f1000")

Please Login or Register  to view this content.

I Want to activate the cell with the value of listbox item which one i select,

for example i select the listbox's value 378 then activate the cell f17
and
if i select 386 then select the cell f22,,,,

note:- select always first value of unique data

thank you

One way would be

Please Login or Register  to view this content.

Thank you for the reply
its saying
run time error 94
Invalid Use Of Null

It works for me with your workbook.

Please Login or Register  to view this content.

i changed it to Listbox1.click

and its working well

but its selecting the last value, while i need to select the first unique value

when i select 187 in listbox then its selecting c31 while it has no value
thank you

Yes
its working very well

thank you very very much