Can A Control on a form in a worksheet be linked to another

slimpickens · Apr 11th, 2002, 11:38 AM

Hi,

I have a forms on a series of wrkbooks which contains comboboxes and listboxes. The only problem I am having is that the wrkbooks will be used overseas, so that means that every time the data changes I will have to email the updated versions. What I want to know is-: Can I have all the controls linked to a worksheet other than the one that the forms are in, so that all I would have to do is email the one workbook? Or is this not possible.

Carol

Tom Schreiner · Apr 11th, 2002, 12:14 PM

Hi
A seperate workbook, textfile, database, webquery, ect..., to update your other workbooks.
I don't see why not?
I don't know how many lists and textboxes you would need to update.
If it's that big of a chore, I would create a macro which would export all of your data contained in your controls to a simple text file, e-mail it, then run another procedure, from the workbooks to be updated, to update themselves. Would not be overly difficult.
I do not know for sure, but I would venture to say that you can link a workbook control to a seperate workbook's controls via the internet. Does anyone know the linking syntax for this?
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 11:38 AM	#1
slimpickens New Member Join Date: Feb 2002 Posts: 35	Hi, I have a forms on a series of wrkbooks which contains comboboxes and listboxes. The only problem I am having is that the wrkbooks will be used overseas, so that means that every time the data changes I will have to email the updated versions. What I want to know is-: Can I have all the controls linked to a worksheet other than the one that the forms are in, so that all I would have to do is email the one workbook? Or is this not possible. Carol

Apr 11th, 2002, 12:14 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi A seperate workbook, textfile, database, webquery, ect..., to update your other workbooks. I don't see why not? I don't know how many lists and textboxes you would need to update. If it's that big of a chore, I would create a macro which would export all of your data contained in your controls to a simple text file, e-mail it, then run another procedure, from the workbooks to be updated, to update themselves. Would not be overly difficult. I do not know for sure, but I would venture to say that you can link a workbook control to a seperate workbook's controls via the internet. Does anyone know the linking syntax for this? Tom