Linking a text box to an external workbook
 

Hi all,

I have a text box within a userform - and I wish to link the input of
this text box to a cell in a worksheet of an external Excel workbook.

So whatever is typed into this text box gets dynamically entered into
the external file/sheet/cell.

Also, is it possible to have this link functional if the external file
is closed at the point of this entry, or does this exteranl file
always need to be opened first.

Thanks for any help.