converting excel formula to vba

[excelkaacc]

hello i am new to vba can any one help me converting this excel formula [FONT=&quot]=INDEX($C$7:$C$2001,AGGREGATE(15,3,IF($C$7:$C$2001=$J$5,ROW($C$7:$C$2001)-ROW($C$7)+1),ROW(A1)))
to vba code
please do mention where to type value that needs to be searched and where will i get the answer
this formula returns multiples matches how to do that with vba
please mention textbox.1 as value where i should enter value to be searched
and
cell (a1), a2 and a3 as cells where i will get answers
thanks for your help in advance[/FONT]