Excel 2003 VB Macro for finding txt strings
Closed
swt
Posts
1
Registration date
Tuesday May 5, 2009
Status
Member
Last seen
May 6, 2009
-
May 6, 2009 at 11:32 AM
psk - May 17, 2009 at 07:45 PM
psk - May 17, 2009 at 07:45 PM
Hello, I am trying to write an Excel 2003 Visual Basic Macro that searches a cell for a particular word. But the cell contains several words. So I can't just use a cell value match formula. Any suggestions would be greatly appreciated!
Related:
- Excel 2003 VB Macro for finding txt strings
- Excel mod apk for pc - Download - Spreadsheets
- Ping to txt file - Guide
- Kernel for excel - Download - Backup and recovery
- Spell number in excel without macro - Guide
- Gif in excel - Guide
2 responses
Hi,
Have you tried using the SEARCH function? This function returns the index of the first occurence of the word within a string. To get the logical value (True or False) instead of the index, you can compare the return value of SEARCH function to be greater than zero.
HTH
Happy coding!
psk
Have you tried using the SEARCH function? This function returns the index of the first occurence of the word within a string. To get the logical value (True or False) instead of the index, you can compare the return value of SEARCH function to be greater than zero.
HTH
Happy coding!
psk
Apologies, missed the fact that you need the *VBA* function for the macro and *not* the excel function for the formulas. You can use INSTR function in the VBA macro to achieve the same.
In addition, any Excel formula can be evaluated by passing the formula as string as a parameter to EVALUATE function in VBA. Hence, using EVALUATE, you can evaluate SEARCH function in the VBA macro too.
- psk
In addition, any Excel formula can be evaluated by passing the formula as string as a parameter to EVALUATE function in VBA. Hence, using EVALUATE, you can evaluate SEARCH function in the VBA macro too.
- psk