Adding a macro?

[sodowarts]

First off, I'm a relative newbie. I found this macro(?) below and would like to add it to a worksheet because it is supposed to make it possible for me to highlight different words. To customize it to my needs:
1. where in the string do I add the words that I want highlighted
2. does it matter if I want to only highlight in one column
3. once customized how do I make it work on my worksheet.

Please Login or Register  to view this content.

Many thanks!

[patel45]

attach a sample file with before and after desired macro running

[brynbaker]

Start the other way around. Open your file in Excel, press Alt+F11. VBA edito. Look at the left pane which should be a sort of tree representation of the elements. Right click the projec name, select Insert... module. Double click the new module. It's blank. Copy the code above and paste in the module.

Now you are ready to amend and test. The line starting Fn=Array... has a number of strings in quotes separated by commas. Insert new, change or delete existing stings for your selection of words. Press F5 - the macro will work.

[sodowarts]

I haven't done anything yet. All I have is a worksheet that I'd like to apply it to. Maybe there's a simpler way to highlight two different words in one column.

[sodowarts]

Thank you brynbaker. It worked....accept when a cell's text included something like DIRECTOR OF SALES (sales was chosen to be one of the highlighted words) only DIREC was highlighted not the word sales. It would only do the first few letters like this in other similiar cells in which the chosen highlighted word was not the first word. Any ideas on how to fix this? Thank you!

[sodowarts]

Start the other way around. Open your file in Excel, press Alt+F11. VBA edito. Look at the left pane which should be a sort of tree representation of the elements. Right click the projec name, select Insert... module. Double click the new module. It's blank. Copy the code above and paste in the module.

Now you are ready to amend and test. The line starting Fn=Array... has a number of strings in quotes separated by commas. Insert new, change or delete existing stings for your selection of words. Press F5 - the macro will work.

Thank you brynbaker. It worked....accept when a cell's text included something like DIRECTOR OF SALES (sales was chosen to be one of the highlighted words) only DIREC was highlighted not the word sales. It would only do the first few letters like this in other similiar cells in which the chosen highlighted word was not the first word. Any ideas on how to fix this? Thank you!

[brynbaker]

That's nice piece of code you found. The line that's giving you hassle is obviously

Please Login or Register  to view this content.

but I can't fault it. It gets the length of highlight right and the start position should be correct with (InStr(1, Lookin, xitem).

You asked about single column use; the line to change is

Please Login or Register  to view this content.

and I think it would be to replace .Cells. with .columns(3). [put the column number you need].

[sodowarts]

So there is no way to change the way it is being highlighted?? (Don't forget -- I'm a xl newbie). Could you do me a favor and write out how the code should read to make the changes? Thank you!

That's nice piece of code you found. The line that's giving you hassle is obviously

Please Login or Register  to view this content.

but I can't fault it. It gets the length of highlight right and the start position should be correct with (InStr(1, Lookin, xitem).

You asked about single column use; the line to change is

Please Login or Register  to view this content.

and I think it would be to replace .Cells. with .columns(3). [put the column number you need].

[brynbaker]

To limit to one line:

Please Login or Register  to view this content.

I can't fix the highlighting. It could be made to highlight the offending cell - replace the following lines

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

but that's not what you want, and the existing code should work anyway.
Best I can do, sorry.