I am working on a small project from work. I have to create a
userform that will take the input and place it into three different
spreadsheets. So far, I think I have the code written that will do
this, but it is in module 1 and the userform 1 in somewhere else.
How do I pass the variables to my main code?



On a different note, I also have when ID = 66502 then y = .cells(c5)

The thing is, I have over 60 different ID to choose from. That is a
big IfThenElse statement. I am currently using a Select Case
statement. Is there anything better?