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

    combo box list fill range (2k)

    I'd like to assign by code the combobox list fill range with the range name from another wbk.

    Something like:

    ActiveSheet.OLEobjects("ComboBox1").ListFillRange= Workbooks("B").Sheets(1).Range("Accounts")

    but I think I need a string rather than a range: was thinking of
    =Workbooks("B").Names("Accounts")

    but so far can't make it work.

    Does xl not allow list fill ranges outside the wbk?

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: combo box list fill range (2k)

    Paul,


    Debra Dalgleish has a technique for data validation lists that could work for you...

    http://www.contextures.on.ca/xlDataVal05.html
    Use a List from Another Workbook

    What you do is create a name in your workbook that refers to the range in the other workbook.
    Let us know if that or something else works for you.

    Regards,
    JIm Cone
    San Francisco, CA

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box list fill range (2k)

    Thanks, I'll give these ideas a try

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box list fill range (2k)

    Without actually trying it, it will probably be something like this:

    <pre> ActiveSheet.OLEobjects("ComboBox1").ListFillRange= "[" & Workbooks("B").Name & "]" & _
    Workbooks("B").Sheets(1).Name & "!Accounts"</pre>

    Legare Coleman

Posting Permissions

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