Jump to next FALSE value button.

[jrawlin7]

Hi all,

I am looking to create a button that will take you one by one to each false value displayed. So on the sheet below the button (yellow) clicked once would take you to Cell D8, then click again and it takes you to Cell D12 an so on until you have seen all the MISMATCH values in Column D.

Thanks,
J

 

[mikerickson]

Sub test()
    Range("D:D").Find("Mismatch", After:=ActiveCell).Activate
End Sub

 

[jrawlin7]

Thanks for your reply @mikerickson I am having a hard time assigning this VBA to the button itself? Would you be able to help?

 

[jrawlin7]

Sub test()
    Range("D:D").Find("Mismatch", After:=ActiveCell).Activate
End Sub

Getting an error when I try to assign to the button, it brings this up.

Please could you offer any more help?

Thanks!!

 

[jrawlin7]

Bump.

Can anyone spare a second to help on this?

 

[mikerickson]

What is the error message?

 

[jrawlin7]

So I have managed to get it semi-working with this:

Sub test()
Range("A:X").Find("Mismatch", After:=ActiveCell).Activate

End Sub

But because the formula for that column features the word Mismatch, it searches them all.....I could do with it being cell colour specific I.e. only look at red cells).

 

[mikerickson]

Use the LookIn:=xlValues argument of .Find.

Range("A:X").Find("Mismatch", After:=ActiveCell, LookIn:=xlValues).Activate