Search box code

  • Where am I going wrong?
    I simply want to search a sheet and find the first cell with the entry.
    I created a button to show a search box asking what to look for but it gives me errors at the end run. I figured it is missing commands telling it what to do when it finds, what it is looking for. I tried some stuff but am still to ignorant at vba. I left the description of what I was trying to do in the code. but erased the code as it had me all kinds of confused.



    The code is actually snippets I pulled from other code so if there is a better way to do this I am open minded.



    Once again thanks in advance.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Search box code


    try this

  • Re: Search box code


    I still get:


    Run Time Error 448
    Name argument not found


    With the chose of debug or end.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Search box code


    Remove SearchFormat:=False.

Participate now!

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