Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting cbo RowSource prop to another Wbk list (2k)

    Is it possible to set the RowSource property of a Controls toolbox CBO to a list in a different wbk?

    If so, what is the syntax?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Setting cbo RowSource prop to another Wbk list (2k)

    You can: set the RowSource to (for example)

    <code>'[OtherWorkbook.xls]Some Sheet'!A1:A8</code>

    This will only work if the other workbook is open. If it is closed, the dropdown list will remain empty (without an error message). It is probably better to create a range in the workbook that contains the combo box, linked to the source range in the other workbook, and use that as RowSource. Even if the other workbook is closed, the dropdown list will still be populated.

Posting Permissions

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