CODEWITHSUNDEEP
excelvba
NCC
NCC

Reputation: 819

How to Find the next value if more than 1 matched Excel VBA

I am trying to make the this search to be able to find the next value if more than 1 matched. enter image description here

Right now, all it can do it shows the first matched.

Basically, if I press button "NEXT" Then it just go to next matched value.

My logic: I think I must do subtract the total range from the current range but I have trouble with this.

Upvotes: 0

Views: 3349

Answers (1)

NCC
NCC

Reputation: 819

Solution can be found

Siddharth Rout's VBA Page

enter image description here

I used a listbox to store the values (Listbox1.AddItem aCell.Address)

Thank you Siddharth Rout

Upvotes: 1

Related Questions