Home/ Questions/Q 6903
Next
In Process
Computing Staff
  • 0
Asked: 2021-11-22T02:55:00+00:00 In:

CTRL F VBA Macro For Multiple Items

  • 0

Hi – I’m new at VBA and wanted to see if someone can help with some coding.

I am trying to use the CTRL F function to search a worksheet that has several words at the same time. We have clients who are risky and we do a “Red Check” to see if they are on a daily file. We then take a snapshot of the CTRL F function if there are no matches. I would like to do the same thing using VBA. Can anyone help out on this or get me started?

Share

    2 Answers

    1. Can’t help with a Macro, but there are ways to do a key word search using the =SEARCH() function.

      • 0
    2. To get you started have a look at the below thread, it may not fit your purpose exactly but try one of the codes by myself or DerbyDad and then let us know what changes you may need, or have a play and see if you can change the code to meet your needs.

      https://computing.net/answers/of…

      message edited by AlwaysWillingToLearn

      • 0