Create a Search Box on Userform: if search result found then do this, if not then do that

Hello everyone! I am new to posting on the forum although I have read many post on here before. I was wondering if anyone could assist me with the following:
I think it should be pretty simple but I am having troubles.

I have a userform called "frmSearch". There are two items on the form: a text box called "txtURL" and a command button called "cmdSearch".

Column "B" of my sheet "Benefit_Resources" contains URLs. I would like user to be able to paste a URL into the search box and search... if the URL is found I want it to open another form called "frmFound" and if its not found then open a form called "frmNotFound".

I have tried the following code but no luck.

Please Login or Register  to view this content.

I have attached a workbook with some sample data and this code in it. It keeps returning the NotFound form even if searching for a URL that is there.


Any help or direction that could be given would be very much appreciated!!

Thanks in advance!


ddavis7SearchBoxExample.xlsm

Welcome to the forum

Pls

Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future