Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo box missing list items (xp xcel 2003)

    Hi everybody:

    This was easy in Access, but my users want an Excel interface. It worked fine yesterday, but not today when I reopened my workbook.

    I'm trying to get two combo boxes synchronized so that when I make a selection (manager) in the first, the second displays the corresponding funds.

    I am using some dataranges on hidden sheets that automatically update the managers and funds from the database on file open. They look fine.
    I have named two ranges that each read 2 different columns on hidden sheets, one for managers and the other for funds.
    I've created two combo boxes from the Toolbox. When a user makes a selection from the managers combo and then clicks the funds combo, the first combo's lostfocus event fires a routine that copies the corresponding values from the selected key into the area that a named range reads: rng.AdvancedFilter Action:=xlFilterCopy, criteriarange:=oSheet.Range("J1:J2"), CopyToRange:=osheet.Range("M:O"), Unique:=True

    The funds combo box's List FillRange is set to that named range =OFFSET(Funds!$N$2,0,0,COUNTA(Funds!$N:$N)-1,2)

    Yesterday, the two combos worked perfectly. Today, when I make a selection in the managers combo, the funds combo only displays the first item in the named range, even though the name's refersto shows all the items. (And yes, the funds combo's listrows property is set to allow plenty of room to list all the funds.)

    Any idea what gives? Or is there an easier way to do this?

    Thank you, in advance, for your help.

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

    Re: combo box missing list items (xp xcel 2003)

    Please post your workbook, with some dummy data instead of the data from the database.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box missing list items (xp xcel 2003)

    Okay, here it is.

    Now, it's working perfectly!

    Frankly, I am baffled.
    Attached Files Attached Files

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

    Re: combo box missing list items (xp xcel 2003)

    I'm afraid a working sample won't help to determine why it didn't work earlier... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Piscataway, New Jersey, USA
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box missing list items (xp xcel 2003)

    Right. However, the workbook has not been changed since yesterday, other than putting in dummy data.
    Same workbook was fine on Wednesday and Friday but not Thursday. So we are both baffled!

    I wonder what Monday will bring?

Posting Permissions

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