Automate the Excel VB Editor Find and Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to write vba code that executes the Excel VB Editor Find and Replace function? If so how?
 
There is no way to automate the full find and replace
functionality in the VBE. It doesn't support a Replace method.
The CodeModule object does support a Find method, so you could
use this to search for the desired text, use the Lines method to
get the text, modify the text as required, use DeleteLines to
delete the existing line and finally InsertLines to insert the
modified text in to the CodeModule.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



jtedge said:
Is it possible to write vba code that executes the Excel VB
Click to expand...
Editor Find and Replace function? If so how?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To protect user's privacy 1
Excel VB documentation and coding asistance 5
Visual Basic Editor Opening and Closing for User 14
How do I find what is in a spreadsheet 4
Add-In macro execution problem 7
A Macro to Do Find and Replace 2
Need a reference 3
Auto Member List in Excel 2004 1

Back
Top