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.