Consulting

Results 1 to 3 of 3

Thread: FindAll on sheet3 then display in sheet1 user form

  1. 05-20-2015, 04:19 PM #1
    tx7399
    tx7399 is offline
    VBAX Regular
    Joined
    Apr 2012
    Posts
    32
    Location

    FindAll on sheet3 then display in sheet1 user form

    Hi everyone,

    From a sheet1 UserForm, how can I find all instances of a user input value that exist in Col A of sheet3?
    Then, for each instance of the user input value, display the values that are in columns A thru E of Sheet3 for that row.
    Can these ranges (A:E from sheet3 for the rows identified by finding the searched for value in Col A) be displayed in some sort of pop up form from the User Form?

    Totally lost; any ideas are much appreciated.
    Reply With Quote Reply With Quote
  2. 05-20-2015, 04:50 PM #2
    Paul_Hossler
    Paul_Hossler is offline
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,730
    Location
    Totally lost
    Me too -- you'll have to mock up an example with a lot more detail I'm afraid
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3
    Reply With Quote Reply With Quote
  3. 05-20-2015, 06:21 PM #3
    tx7399
    tx7399 is offline
    VBAX Regular
    Joined
    Apr 2012
    Posts
    32
    Location
    I'll try to come up with some test data.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules