I had thought about alternative ways to accomplish this. The two I came
up with was either making the userform have the information placed in it
and then it updateing the spreadsheet; which was a little more time than
I want to put into this code.
The other and the one I was leaning to was as you said to have more code
connected to the command button on the userform that would complete my
code, but when I did that I ran into a problem with a nested End Sub in
the main code. See, the userform is nested in an if then statement and
only appears under certain conditions therefore I need an End Sub in the
if statement to end the code. .... Idea just poped into my head. If I
have a GoTo function in the if statement can I jump to the end? Can
anyone help with the syntax of a GoTo function in the Code? The help
mentions GoTo in the spreadsheet and a ON...GoTo but not a GoTo in the
code.