+ Reply to Thread
Results 1 to 3 of 3

keep listbox filled

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    keep listbox filled

    Hi al,

    I created a database that keeps all emails stored. The form looks pretty much as outlook to make things logical. In the form I have 2 listboxes that act as the folders and subjects of the emails and then I have the reading pane. The first listbox shows all the folder there are, When I select a folder, all the emails that it contain show up in the second listbox. When I select a subject from an email, it will show the data inside the "reading pane" in the form (based on the ID nr that the email has). When I click on the email and it shows up, all the subjects from the second listbox disappear. How can I change the below code so that it will not happen? Any help to solve this mystery would be appreciated.

    Greetings.

    Please Login or Register  to view this content.
    I also posted this question here: http://www.access-programmers.co.uk/...d.php?t=273679

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: keep listbox filled

    Hi,

    No one has a clue how to solve this? There must be some easy solution for this, it is just that I can't come up with one as my vba knowledge is not the best one yet.
    Maybe there is a different way to do it different and get the same results.

    Greetings.

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: keep listbox filled

    Hi all,

    It got solved, see below link:

    http://www.access-programmers.co.uk/...=273679&page=2

    Greetings.

+ 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. Listbox Click event problem - last and not current clicked data gets filled in form
    By wonderolga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2014, 09:04 AM
  2. Replies: 4
    Last Post: 08-26-2014, 02:44 PM
  3. [SOLVED] A re-usable Form with a listbox filled with an array defined when .SHOW - how to define?
    By Skotzmun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:20 AM
  4. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  5. Blank lines in array filled listbox
    By macquarl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2008, 12:42 PM

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