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

[slimpickens]

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

 

[Legacy 98055]

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