find and replace text within a known module

[jarhead58]

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

 

[Joe4]

I think I'm over thinking it! I think I'll just use a Select Case for the different options within the ChangeSheet procedure. I'll see if that makes it easier. Thanks for the help Joe4!!

OK. Based on what you said, I astill don't think I clearly understand what you are after, so I am not sure how helpful my replies were. It is all a bit abstract, without seeing your data and code.
Examples/images are often much more helpful in explaining things.

 

[jarhead58]

Sorry for the delay in responding! I decided to go about it a different way! Thanks for the help everyone!