+ Reply to Thread
Results 1 to 2 of 2

Dynamic listbox will not update when new names added to colum A

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Dynamic listbox will not update when new names added to colum A

    I am trying to create a dynamic listbox to shorten the range of the selection so when you scroll down you do not have blank spaces at the bottom. In the attached spread sheet the the listfillrange auto updates however it does not show up in the list.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Dynamic listbox will not update when new names added to colum A

    Hi, welcome!
    perhaps soemthing like this
    Please Login or Register  to view this content.
    *delete the ListFillRange from your ListBox

    or
    Please Login or Register  to view this content.
    Last edited by blue.chio; 08-22-2013 at 03:50 AM. Reason: added note
    blue

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Access manually added ListBox in VBE
    By vizzkid in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-16-2013, 10:08 AM
  2. Replies: 12
    Last Post: 08-28-2012, 07:09 AM
  3. [SOLVED] avoiding duplicates in listbox (added from another listbox)
    By KR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2006, 04:15 PM
  4. [SOLVED] Multi Colum Listbox in UserForm
    By Zani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2006, 08:10 PM
  5. [SOLVED] Colum heads in multcolumn listbox
    By Alen32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2005, 04:06 PM

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