Why not just use the controlsource (userform) property to link the textbox
to the cell.

--
Regards,
Tom Ogilvy

"Sony" wrote in message
...
Thank you Julie that was exactly what I needed

"Sony" wrote:

I want to populate a specific cell with information entered on my
userform in
Textbox1. It will always be the same cell so I will not need to put new
input on next line. Thank you in advance for your help.
--
Sony