Tell us more about what you are trying to accomplish (not necessarily how).
Once this "text box" is populated, what do you want to do with it?

Create a Simple Userform by Graham Mayor, MVP