Linking a text box to an external Excel workbook

J

JENNA

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 external file
always need to be opened first.

Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Follow up question for Tom Ogilvy - re: linking a text box to an external workbook 2
Disconnecting from an External Workbook Data Source 2
Looking for some help launching files from COde & Ribbon control 0
write to external workbook from userform 1
Macro that will insert a simple text string in top cell of text file 1
How do I save external data in Excel? 3
How to convert concatenated text to a link to an external workbook 3
Help - How to check if value exists in closed workbook? 3

Top