Find(search) value from multiple worksheets and display it in labelbox

Hi, i need a little push about something, and that is following:

I have four sheets (sheet1, sheet2, sheet3 and sheet4)!
Also, i have a userform with: 1 commandbutton(where I need to put right code), 1 textbox (search criteria input) and 1 labelbox! (no matter about names of them)

Now, let's say that i have a number "2" for example, in those sheets, but in diferent positions(in sheet1 in B1, in sheet2 in c4, etc(but never in columnA), I want to find that number, and display number/text (NOT THE SAME IN ALL SHEETS) one cell left to that number(from that worksheet)! Now, when all cell containing number "2" in current sheet are found, then it should move to the next sheet, and so on!

I have something close to what i want, but problem is when all sheets have matched find criteria, then all i got are data from the last one! (it skips to show me data from previous sheets which have matched finding criteria)!

It is here:

Please Login or Register  to view this content.

THANX IN ADVANCE!!

Try this,

Please Login or Register  to view this content.

Is a label going to be suitable to display multiple finds?

Hi, andy, thanks for the quick response!

Nope, that doesnt solve my problem! All i got is "nothing found" message!

I would like you to take a look on my codewith original names now)

Please Login or Register  to view this content.

I just have problem when 2 sheets have requested value! I want when i click on command button to go :first on cell containing wanted value, and then if there is no sign of that value in current sheet, when i click command button, to go to the next sheet which have my value!

THANX ALOT FOR YOUR EFFORT!

If its easier, forget about label box, and just concentrate on finding and selecting cells which have "requested value"! (But very important to me is switching between the sheets which have my value! Also, you can work with default names of objects! Commandbutton1, Label1, and Textbox1 so as Sheet1, Sheet2.....

THANX!

Can you post a example workbook. Explaining what to search for and where it would be found.

Hi,

Sorry about neglecting this thread for a while, but be sure that i was looking for possible solutions and i "nearly" found it!

Please, check the workbook i attached, and there is request!

I must admit that i used already created userform i downloaded from this site, and i bit rearranged it for my purposes, but the problem still remains! (It will be clear when u open the book)!


MANY THANKS FOR EVERYBODY WHO IS MAKING AN EFFORT SOLVING MY PROBLEM!

As I suggested before you need to loop through the relevant worksheets.

Please Login or Register  to view this content.