Mismatch error with find next

  • Hi,

    I'm trying to create a user form that searches through a sheet and displays results found. My first case is searching by name, and as some names appear more than once I'm trying to create a loop where every time a button is pressed then the next result is displayed and will loop back to the top of the sheet when it reaches the bottom.

    This is the code I'e got so far, but at the moment there is a mismatch error occuring with found1 is false. Any pointers to what is wrong at the moment?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!