+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Registered User
    Join Date
    01-25-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    15

    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!!
    Gandrinno

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,526

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

    Try this,

    Please Login or Register  to view this content.

    Is a label going to be suitable to display multiple finds?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-25-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    15

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

    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!
    Last edited by gandrinno; 02-21-2009 at 05:08 PM.

  4. #4
    Registered User
    Join Date
    01-25-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    15

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

    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!

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,526

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

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

  6. #6
    Registered User
    Join Date
    01-25-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    15

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

    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!
    Attached Files Attached Files

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,526

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

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

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1