Does anyone have a macro that searches all other macros in a workbook for a specific term and changes that term to something else the user has indicated by an Input Box entry ?
I've looked online and located several examples but none of them work. ???
Thanks
Do you want to edit live macro code in your VBA project?
Please descibe some more details.
The process I am seeking is to replace all instances of a term with another term, throughout the workbook modules. This 'replace term' macro will utilize two Input Boxes ... one for the search term and a second indicating
what term shall be used as a replacement.
So ... the user clicks a command button and the first Input Box is shown requesting what term to search for throughout the modules. Then the second Input Box is displayed and this requests the term that will be used to
replace the existing term when found.
What is your 'term'?
VBA keyoword, Variable name, number or Text...
The term will be text.
You can use variables, and apply user answers.
Please Login or Register to view this content.
This will give you an idea...Credit to snb
Set reference to "Microsoft Visual Basics For applications Extensibility" & Check the Box "Trust access to the VBA Project object module" in Macro Security settings...
Place code in an external workbook...you can amend with input prompts...
Please Login or Register to view this content.
Last edited by Sintek; 11-03-2024 at 08:19 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Sintek your code works very well with the regular modules. I tried editing the code so it would apply to the sheet level modules as well but without success.
Any thoughts ?
See amended code :
Please Login or Register to view this content.
Each sheet is vbext_ct_Document...
Please Login or Register to view this content.
NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
You can say "Thanks" in your thread to everyone who offered to help you.
You can also reward them by clicking * "Add Reputation" under their username on the left.
With Regards, MikeVol.
2 is for class modules...
Please Login or Register to view this content.
Last edited by Sintek; 11-03-2024 at 10:43 AM.
Thanks for everyone's assistance.
Glad you got it sorted...Tx for rep +
It was my pleasure to help you. Thanks for rep - Up!
I did some editing to better suit my needs. Here is the code for others to enjoy ...
Please Login or Register to view this content.
Just be careful...That snippet change to activeworkbook wil effect the Main macro too...Might have to add a snippet to exclude...
Place it it a stand alone module and include ... i.e.
Please Login or Register to view this content.
Last edited by Sintek; 11-03-2024 at 02:18 PM.
I believe this method carries significant risk.
Please be very cautious when deploying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks