+ Reply to Thread
Results 1 to 5 of 5

Creating Multiple search tool (currently single criteria search) and reporting to Main Pag

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    3

    Unhappy Creating Multiple search tool (currently single criteria search) and reporting to Main Pag

    Hi,

    I have the following code in my workbook created with help from various sources online and some playing around on my own.

    Please Login or Register  to view this content.
    This only allows me a single string search. Now I have this working, what I really need is a multiple string search e.g. Criteria 1: Flange, Criteria 2: ASME and so on with maybe up to 5 Criteria if this is possible.

    As in my current code this needs to search all worksheets in my workbook.

    Really hoping someone can help me out,

    Thank you,

    Gary
    Last edited by Gluv1983; 05-20-2014 at 09:39 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Creating Multiple search tool (currently single criteria search) and reporting to Main

    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



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Registered User
    Join Date
    05-20-2014
    Posts
    3

    Re: Creating Multiple search tool (currently single criteria search) and reporting to Main

    My apologies, I have corrected my error.

    Kind Regards,

    Gary

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Creating Multiple search tool (currently single criteria search) and reporting to Main

    maybe to add Array and then enter myText as one word separated with space.
    Then you can Split myText by space and add one more loop Array(i) from 0 to UBound

  5. #5
    Registered User
    Join Date
    05-20-2014
    Posts
    3

    Re: Creating Multiple search tool (currently single criteria search) and reporting to Main

    Quote Originally Posted by zbor View Post
    maybe to add Array and then enter myText as one word separated with space.
    Then you can Split myText by space and add one more loop Array(i) from 0 to UBound
    Hi Zbor,

    Thank you for your time, I really appreciate it.

    I am pretty new to the world of VBA. Could you give me an example of what you mean please?

    From what I understand it is the following:

    Please Login or Register  to view this content.
    I know that this is probably wrong. I also would as where this would be placed in my code.

    Thank you kindly for your help,

    Gary

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP: Creating a Search Tool using Excel 2003
    By icesaiah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 07:21 PM
  2. [SOLVED] How to return multiple values that match a single search criteria?
    By JSallen in forum Excel General
    Replies: 4
    Last Post: 11-28-2012, 11:49 AM
  3. Replies: 9
    Last Post: 01-22-2012, 01:31 PM
  4. creating VB code using advanced search criteria with multiple data validation lists?
    By Jonathan Bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 09:56 AM
  5. Allow Multiple or Single String Search Criteria Macro
    By eurydice88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-20-2009, 02:50 PM

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