search find macro

  1. B

    Searchbox in Excel

    Greetings I've been searching for a way to create a Search Box to search my Workbook. I found some code on this site, and while, it does work, there are a few things I don't like about it. Here is the code I'm using (slightly edited from it's original): I'm using Excel 2016. Sub FindRadio()...
  2. S

    Search for specific list of words in a column and return specified values in another column

    Hi There I've been searching through the forum (please feel free to point me to the right post if I missed it) and couldn't find what I was looking for so I was wondering if someone might be able to help. Trying to identify a macro that will search a column of cells for certain words and if it...
  3. H

    Look up and return a name in the relevant row Loop

    Hi I have a Column A of mixed up names (the mix sometimes contains long codes), eg. 1234_treadmill* b812 bicycle ops+keyboard rf_treadmill- b812 bicycle_87 ops bicycle_&* mouse et.<33> And I have a Column B of simple names, eg. treadmill bicycle keyboard mouse I want a macro to go...
  4. C

    Starting Search Companion with VBA

    Is there a way to do this? The user opens an excel workbook. in cell E17 on a sheet that is named "Work" is the name of the file w/o the extension. Example, file name is 123456Q1.xls in cell E17 is 123456 The user wants to find all files with 123456 in the file name in the Quote directory or...
  5. N

    Need a search function (or macro...)

    Hi I have a worksheet with 4 columns - 1 of which is employee name and one of which is employee number. I need to be able to search this list for specific names (the numbers function I can do.) The problem with searching names is we have more than 1 Bob, etc. Also, when using a name search...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top