+ Reply to Thread
Results 1 to 5 of 5

Combobox ListFillRange using dynamic named range not updating

  1. #1
    Forum Contributor
    Join Date
    08-20-2012
    Location
    Walsall,England
    MS-Off Ver
    Excel 2007
    Posts
    125

    Combobox ListFillRange using dynamic named range not updating

    Hi,

    I have a combobox on a worksheet. The ListFillRange is a dynamic named range (uses INDIRECT). The named range changes based on a number entered in a cell. I have checked the named range and it is updating fine when the number changes. However, the combobox does not update correctly. Any ideas?

    I've attached an example of the issue.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Combobox ListFillRange using dynamic named range not updating

    Use this for your dynamic range

    =OFFSET(Sheet1!$I$1,0,0,Sheet1!$J$1,1)

  3. #3
    Forum Contributor
    Join Date
    08-20-2012
    Location
    Walsall,England
    MS-Off Ver
    Excel 2007
    Posts
    125

    Re: Combobox ListFillRange using dynamic named range not updating

    Hi, thanks for the reply. I've added your offset formula and the combobox still does not update??

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Combobox ListFillRange using dynamic named range not updating

    activex controls suck-especially on worksheets. use a forms control or a data validation dropdown instead if you can
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Combobox ListFillRange using dynamic named range not updating

    I agree with JP, the ACTIVEX one seems to only get the range at its creation, i've attached a file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1