Search and replace VB with VB

[Mayweed]

Does anyone know a way to search and replace a word in VB with VB?
For example... run a macro to search through all the VB contained in a workbook and replace the word orange with the word lemon.

[snb]

Please Login or Register  to view this content.

[Mayweed]

Thanks Snb but I can't get it to work, I've attached a workbook to demonstrate what I mean.
After running one macro, all messages containing the word 'Lemon' should read 'Orange'.

[snb]

You can't put this code in the same workbook you want to adapt.

[Mayweed]

Ahhh. now I've got it. Thanks Snb, just what I wanted.