Question on: frmendyear.txtto.Text

frmendyear = The name of your userform
txtto = The object name you are using (textbox)

The reason I ask is that errors is saying it cant find the object you are referencing. I tried it both ways one creating a userform and naming it frmendyear and then creating a textbox named txtto which worked fine. However after I deleted the userform the error you stated was returned.