I can code this to work correctly as long as it is inside the Userform code but I cannot use these variables inside the Macro. It appears as if the variables are not recognized.
You may want to rethink doing what you are suggesting. I'm not sure why you think it will help to begin with.

To do what you want, you will have to declare all of your variables publicly, in a standard module and you will have to reference every userform, control, etc. specifically.

Just my two cents.