+ Reply to Thread
Results 1 to 6 of 6

Listbox pre-selected items

  1. #1
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Listbox pre-selected items

    Dear expert,

    Please find attached file with below details and requirement.

    CURRENT FUNCTIONALITY:
    1. Click on “Button2” on Excel sheet. “UserForm1” will open.
    2. Click on “CommandButton1”, “UserForm2” will open.
    3. Select multiple weekdays (any 2 or 3) Click on “CommandButton1”.
    4. TextBox will be populated with the selected Values.
    5. Again if you click the “CommandButton1”, “UserForm2” will open with fresh option of selection, if you continue the process it will over write the values of text box.

    HELP NEEDED (REQUIREMENT)
    1. If the textbox has values (in short if we populate the selection list for second time) the values available in the textbox should be selected in the list.
    2. i.e. if textbox has value “Monday” and I popup the list, “Monday” should be already selected.
    3. If then I select “Tuesday” (along with Monday selected) and submit. Textbox should have both the value. That means added values.

    Immediate help will be appreciated.


    Thanks
    MG
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Listbox pre-selected items

    Only 1 form


    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: Listbox pre-selected items

    Sorry Leo Sir,

    But my design will not work with single form, as it contains multiple items and the main user form doesn't have that much space were i can locate these details.

    Hence i have created popup form and need to work on the Base Sample file I have shared.

    Please help on the same.


    Thanks
    MG

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Listbox pre-selected items

    Change "one" to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: Listbox pre-selected items

    jindon; you are my Superhero!!! This is what i was looking for.
    Let me check the same in my code (after modifying accordingly)

    Thanks
    MG

  6. #6
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: Listbox pre-selected items

    Hooooorrrrray!!!!! It's working as expected jindon. Thank-you very much. Really appreciated.

+ 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. VBA - Store selected items in listbox
    By Nisseluren in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2015, 05:57 PM
  2. [SOLVED] Add Selected Items From One ListBox to Another ListBox on UserForm
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:53 PM
  3. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  4. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  5. Setting listbox items selected
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2008, 01:57 PM
  6. [SOLVED] How to use selected items from Listbox
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2006, 11:10 AM
  7. ListBox Selected Items into an Array
    By jtp550 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2005, 07:44 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