That would likely work, unfortunately it would be quite a task to rewrite my whole macro just so that I can have the macro on the userform. If there is an alternative way to simply pass through the variable have the userform change it and spit it back out into the general module that would be fantastic if not it looks like I have a lot of work to do.