How to create a search button

[Rosco81]

I am looking to have a search button actually search through all my sheets, i want it to search through column A, numbers & text. I have inserted a search button and a text box, but i can't get either to work.

This is my code i have picked up from other sites, can someone please help!
Thanks in advance

Please Login or Register  to view this content.

[/CODE]

[StephenR]

Welcome to the forum.You need to add code tags (#) as per the forum rules.

[StephenR]

I'm getting some weird run time errors trying to run your code so I can't really help, but look at the Find method perhaps. Someone else may help.

[Rosco81]

I'm getting some weird run time errors trying to run your code so I can't really help, but look at the Find method perhaps. Someone else may help.

By looking at my code is there any way you think i could make this work?