Results 1 to 10 of 10

dynamic range in combo box

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    dynamic range in combo box

    I want to use a dynamic range in a combo box. The formula seems to work fine. When I inspect the range by clicking on the formula field in the 'name manager', I can see the field expand or contract, as expected, when I add or delete data.. I am using =OFFSET(Applicants!$A$1,1,2,COUNTA(Applicants!$A:$A)-1,1). The formula appears to be doing its job.

    I typed the name into the ListFillRange field of the combobox. When I add names into the field I now lose the bottom of the range in the display of the combobox. In other words, once in the combobox, the dispalyed field is not dynamic. But the field in the data page expands just like you would expect.

    Is there a solution. Thanks for your help.
    Last edited by Ziggy943; 08-21-2011 at 03:37 AM.

Thread Information

Users Browsing this Thread

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

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