+ Reply to Thread
Results 1 to 4 of 4

Setting listbox items selected

  1. #1
    Registered User
    Join Date
    05-22-2008
    Posts
    74

    Setting listbox items selected

    In the "Selectionchange" of a worksheet a form is populated with items from the worksheet. One of the controls is a multiselect listbox that has several classes listed. I want to pre-select the classes that match the details of the worksheet. For example;

    Worksheet Class1 through 6 has data 3, 8, 9, 11, 14, 16. The list box has items 1, 2, 3, 5, 8, 9, 11, 12, 13, 14, 16, 18, 23, 24, 32.

    When the form is shown I want to be able to see the selected items in the list box where I will either select more or deselect some.

    Thanks.
    Last edited by scottintexas; 07-20-2008 at 10:07 AM.
    Scott
    The harder it gets the happier I am.
    Finally got my signature set up!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Scott

    Where is the data located?

    And how is the listbox populated?

  3. #3
    Registered User
    Join Date
    05-22-2008
    Posts
    74
    The data is located on the worksheet. Unfortunately (I just found by stepping through) the list box is not populated when I thought. Usually the list box is populated on a combobox change event. So I have to figure out how to fill the list box first, then select the items.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Scott

    You really have to give us some more information if you want us to help.

+ 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