Modify code at runtime

At runtime a combobox userform is created with the necessary code. Also at runtime several worksheet codemodules are generated. All of this works fine. Also at runtime a dynamic named range is created based on user input of a job number. This range is used in setting the row source for the userform combobox. I have a line of code that needs to have this range as the row source, instead of the dummy one that was used. I am able to print the line I want to change in the immediate window but can not figure out how to change it. I am not overly familiar with the code module properties but I would like to know how to replace this line of code, any assistance would be greatly appreciated. I am using Excel 2010 with Windows 7.

Thank you for your reply but I have solved the problem.

The way I solved the problem was to add the code module once the user input was received. Initially, I added the code module for several sheets as the workbook was opened, I removed the part that depended on the sheet using the user input and added it after the input was received.