+ Reply to Thread
Results 1 to 5 of 5

Update listbox (forms)

  1. #1
    Registered User
    Join Date
    09-23-2004
    Posts
    65

    Update listbox (forms)

    Is it possible to update a forms Listbox, without loading the form?

    Example;

    I made a program so that, when pressing a button (submit), values are sorted in two groups. So evry time i press sumit, a new row of one group is added.

    Now, for further use, I created a form with a listbox...in this listbox, the values of one group need to be linked.
    Because of the fact that the range is NOT constant, I am having problems doing so.

    Anyone suggestions,

    Thx a lot!
    Zurn

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

    Re: Update listbox (forms)

    Did you ever figure this out? I have a similiar issue. I need to have the rangefill to be dynamic. I have something close but I not get the last name in the list.

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

    Re: Update listbox (forms)

    you ought to be able to use the Initialize or Activate events of the form to populate the control in code-can you give more detail?
    Josie

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

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

    Re: Update listbox (forms)

    Here is what i have

    Please Login or Register  to view this content.
    I have tried two different ways to update the listfill range. It only seems to work when I edit the script

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,964

    Re: Update listbox (forms)

    zeb4321,Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ Reply to Thread

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