CTRL F VBA Macro for Multiple Items

August 25, 2013 at 19:39:08
Specs: Windows Vista
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?

See More: CTRL F VBA Macro for Multiple Items

August 27, 2013 at 14:26:40
Any help on this would be much appreciated!

Report •

August 27, 2013 at 17:11:31
Can't help with a Macro, but there are ways to do a key word search using the =SEARCH() function.



Report •

August 29, 2013 at 04:58:42
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.


message edited by AlwaysWillingToLearn

Report •

Related Solutions

September 7, 2013 at 09:40:18
Will do. Appreciate your quick reply. Thanks!

Report •

Ask Question