Yes, I believe so, but you are going to have to provide more information before we can tell you how to do it. What is the name of the UserForm? What is the name of the TextBox? What is the line of code you want to put it "straight into"? Where within that line of code did you need it to go?