find and replace text within a known module

Hey all!!

I have a form that opens when I open a workbook. I use the form to open another workbook via a drop down list. I use Select Case to open the chosen option. What I'm looking to do is change wording in a module in the first opened workbook. How would I use the Find..Replace method and is it possible?
For instance, the option chosen is "x.xlsm". I then want to access a module from within the first workbook opened and change a line with "y.xlsm" to "x.xlsm" TIA

Originally Posted by Leith Ross

Hello jarhead58,

Here is a macro that will change the text in a VBA Module. You will need to customize it a little for your needs.

Please Login or Register  to view this content.

Thanks for the help! I was doing the wrong coding! Sorry for the confusion!!