Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •