Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking a text box to an external Excel 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 external file always need to be opened first. Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking a text box to an external Excel workbook
The workbook would need to be open.
Regards, Tom Ogilvy "JENNA" wrote in message om... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable substitution in a formula linking to external workbook | Excel Discussion (Misc queries) | |||
Linking text to external workbook's sheet | Excel Discussion (Misc queries) | |||
How do you locate External References in an Excel Workbook | Excel Discussion (Misc queries) | |||
Linking a text box to an external workbook | Excel Programming |