i prefer a different way of doing the same thing...
instead of calling this cell A1 name it as "sample", for instance.

then write this code under the userform initialize (if you are not sure where to write it, double click the userform, it will show you "Private Sub userform_click()" then you switch it to initialize)

Private Sub userform_initialize()

textbox.controlsource = "sample"

end sub

it will do the same thing as writen above, but im not sure if the other method will let you link the textbox straight to a named cell, no matter in witch sheet you have the info.

hope this help you out.

MP