Results 1 to 5 of 5

Combobox ListFillRange using dynamic named range not updating

Threaded View

  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

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