Search Macro button help

[stanton17]

Hi I have a Knowledge database spread sheet that stores defects. It has 4 sheets Instructions, Input, DataSheet and lookuplist. On the Input sheet I have a Search button with VBA code that displays a msgBox and searches for keywords entered then tells you how many it has found. The problem I am having is that I cant work out how to get the code to only search the DataSheet because at present it searches every sheet and I don't want that.

Please can someone help me. here is the code

Please Login or Register  to view this content.

[mehmetcik]

Firstly:
You will get a lot of abuse for not using code tags.

edit your post

select your code and click the # in the menu bar.

Secondly:

You have programmed your search routine to search every sheet.

Please Login or Register  to view this content.

[xladept]

Hi Stanton,

Welcome to the Forum!

Here's a quick fix (see red):

Please Login or Register  to view this content.

*Notice that I put code tages around the code - here are instructions for that:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] 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

[stanton17]

I apologise for the way I posted the code, I will make sure I use code tags in the future
Thank you for the code it worked perfectly.

[stanton17]

xladept

Thank you for the code

[xladept]

You're welcome and thanks for the rep!