excelkaacc
New Member
- Joined
- May 10, 2019
- Messages
- 4
hello i am new to vba can any one help me converting this excel formula [FONT="]=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]
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]
