Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: imagoodwon
  • Content: Threads
  • Order by date
  1. imagoodwon

    Search a range in a specific order

    I thought I had posted this before, but I didn't see it showing up. I want to find the first instance of a search result starting top left, and then progressing right through that row, then starting agin on the next row top left to right etc..etc.. How can I code this using vba to...
  2. imagoodwon

    excel VBA search pattern

    Is there a way to force findALL or FindNext to return values from 1st found left to right.Top row to bottom row? I have a range A2:L100 and I need to find the first match, D4, then the next one on the same row etc; There will be multiple matches . I want the find to operate one row at a...
  3. imagoodwon

    Match listbox selection to worksheet row

    Hi: Not too well versed on this stuff! I have a userform that gets populated by the user selecting values from a Listbox I read values into some textboxes like this Private Sub ListBox1_Change() Set SourceRange = Range(ListBox1.RowSource) TextBox1 = ListBox1.Value TextBox2 =...
  4. imagoodwon

    Match & Copy ranges on multiple workbooks

    How do I structure VBA code to do the following: I have 2 workbooks, bk1 & bk2 From bk2 Col A, look at bk1 col A If there's a match on Col A, compare the range at bk 2 ActiveCell.Offset(0, 1).Resize(1, 5) and compare it to the corresponding range on bk1 If there's NO MATCH on Col A...

Part and Inventory Search

Back
Top