VBA Check if Sheet Exists, if it does, run code. Test File Attached

Search Results Test.xlsm

Hello, I'm a VBA Novice, (Trying to learn) and have the following issue, I'm trying to create a Search Function which will search data on my ("Database1") sheet and copy it to a new sheet called ("Search-Results"). Currently my code checks to see if ("Search-Results") exists, if it does not, it then creates it and pastes the data to it. This part of my code is working exactly as I want. As soon as ("Search-Results") is created it switches to it and shows the user the results of the search they just ran. My problems start when ("Search-Results") already exists. So when ("Search-Results") already exists, the code should then simply skip the sheet creation line of code and do everything else the same, but I am having trouble with achieving this. Atm, i have an IF MsgBox line that states "One or More Matches Found!" if the user's search has matches. I would like this MsgBox to not be there. The reason I dont simply delete it is that when I do it breaks the code that checks if the sheet already exists and it trys to create a 2nd sheet called ("Search-Results") which ends in failure. So to best demonstrate whet I would like to achieve, plz download the attached copy and click the "Enter Data" button which brings up my Search Userform, Input "Allen" as a Search and you will see the code creates ("Search-Results") and shows the results found for "Allen". (This is the part that works) Then input "John" and hit Search again and you will see the difference. All help is greatly appreciated!

Thanks for your reply!
When I try to run that code as stand alone it gives me a debug error.

If wsResults Is Nothing Then

Above is the line that gave me an error, and it was when the sheet did not exist. Not sure what error trapping is sorry.. im very new to vba

Please Login or Register  to view this content.

The code above works great stand alone and obviously only works if the Sheet "Search-Results" already exists

The code below works great stand alone and obviously only works if the Sheet "Search-Results" does NOT exist.

I need to bring these 2 codes together and make them work as one

Please Login or Register  to view this content.

http://i.imgur.com/vboq6Ua.png
http://i.imgur.com/IfLpAwv.png

Originally Posted by unit285

Please Login or Register  to view this content.

The code above works great stand alone and obviously only works if the Sheet "Search-Results" already exists

The code below works great stand alone and obviously only works if the Sheet "Search-Results" does NOT exist.

I need to bring these 2 codes together and make them work as one

Please Login or Register  to view this content.

Is there anyone who can help me put these 2 codes together and make them work as 1 macro?

Was able to stitch it together myself. Thanks for your efforts Norie

Please Login or Register  to view this content.