|re: I am trying to copy all of my code from module 5 and replace all values containing "PRGNAME" with txtNewProgram.Value |
Do you mean that you want to change the macro itself to read txtNewProgram.Value everywhere that it says PRGNAME?
If so, you can use Edit Replace...Replace All in the VBA editor, just like you can in an Excel worksheet.
If you don't want to Replace All, the Find Next...Replace option is also available so that you can pick and choose which values to Replace.
If you want to limit the changes to a specific section of code, highlight that section of code and then do an Edit...Replace.
re: I then want to paste all of this code into Module 3 at the end, such as not to overwrite the code already there.
Highlight the code in Module 5, Right Click...Copy, double click Module 3, scroll to the bottom and Rightclick...Paste. As long as there are no other pieces of code with the same name in that module, you should have no problem.
re: I would like the code to be able to add to the end of module 3 every time.
Every time? Every time when? You'll need to explain that one in a little more detail.