You need to assign a public variable on a standard module and have that
variable equal the textbox, when the userform is unloaded the public
variable unless set to nothing will be the last value of the textbox.


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32986