Macro for Find Button command

Hello
I am looking for a code for the "FIND" button in the worksheet vba code that when I click the button will search the particular item that I am looking for. For example, I am looking for "HOURS" that is in Sheet2 "when I click the button then it will find the it.

See attachment of the sample file.

Im confuse :0(

Hi Keebellah
I don’t work vba and no knowledge of it. Maybe just a very little.
Thanks

Hi K-
I will next time.
Wow! I liked it a lot :o)
I am learning little by little but it is really complicated especially my English is not very well.

Can you do me another favor....
What if I just want to search just specific sheet like Sheet2 and does not include Sheet1.

Thanks :o)

Hi K-
Wow! you're a genius. I want to be like you :o) I start studying and learn the basic vba but like I said, its way too complicated for me. But with your help and the others here in the Forum, I am achieving something.

I am Asian and I do have a lot of great Spanish friend. Yo hablo espanol poquito :o)

Thanks again K-


Thanks again

K-
I am trying to add Sheet3.
should it be like this?

Set ws = Worksheets("Sheet2,Sheet3")

Thanks.

Hi K
;o) loop? I tried most of i can think of. None of my try out did not work. Sorry...

Set ws = Worksheets("Sheet2”,”Sheet3”)

This did not work either.

I actually pretty much youtube on the basic vba lessons.

Thanks

Hi K-
Wow! It will be a long journey for me :o)

Ok, i will check the site yoo provided.

Thanks you again.

Good morning K-
I have encounter a little issue in the workbook. Most of the worksheets has same item for example "apple" but has a different amount. When I click the button and it only search one item in the workbook and if I click again it just stay there. I need a message that will say "find next" then when it locates the last one then it will say "that's it folk :o)".

Thank you my friend

This code is for finding the entire workbook:

Please Login or Register  to view this content.

Hi
Sorry, did not think of it until i play around w the workbook.

I actually just want to go “find next” because when it located it highlight the cell then If its not the one then i will just keep clicking the button until i see what i needed.


Thanks

The duplicates “apple” will be in a different column. It is not always in same row or column.

Thanks

Hi K-
I attached the sample workbook and each sheet has an "apple".

Thanks :o)

Hi
Aaaah.... i don’t know if i understand your question but i think right?
Did u see the workbook i attached?

Thanks

K-
Here is the attachment just in case you did not get it before.

Thanks.

Hi
Just the word “apple”, or “peach” or jist whatever i need to look for. The apple or whatever that it can be enter several time in Sheet1 and some located in other sheet.

When u say value what is that mean?

Hi
I like it :o)))
but there is more. It only searching for "Apple" what about if I search for "Orange" or "hours", "house", etc.

Thanks.

Hi
Seriously, when i type “apple” in the box then it searches all the apples in the workbook. So then, i try to search “hours” or the “banana” from the workbook but it is not doing anything. Try it from ur workbook you sent it to me and you will see what i meant.

Thanks

Hi
I don’t know why it does not work on my part.

What version u have?

I dont know why it doesn’t work in my part.
I am doing exactly what u have in the images

Hi,

Can you please resend me your workbook and hopefully will work.

Thanks.

Hi K-
For some reason it is not working in my part. Maybe you have a latest version.

Thank you.

Ok Good night :o)

Good morning :o)
I think I figured it out and it took a while. When I was in Sheet1 where the button is, I was searching the "banana" and it was not searching it because the workbook only searching Sheet2 and Sheet3. Can you make it to search for the entire workbook?

Also, I like the way you have the Box where the item is in Sheet1 or Sheet2 or Sheet3 and where the cell is. Can you add the item and value?

Something like this: Let Say "apple"
o Sheet1 $A$3 Apple $2
o Sheet2 $C$6 Apple $200
o Sheet3 $D$1 Apple Uknown

I Attached the file.

Thank you

Hi
Yes i just learned what is value :o)
Since my english is not good and it actually takes a while before i will understand.

Apple is to say as an example... i guess

Thanks

Hi
Ok..
Will you be able to fix it for me?

Thanks.

Hi K-
This is way perfect!
Well, I want to say Thank you for all.

Have a nice day :o)