+ Reply to Thread
Results 1 to 9 of 9

Select Listbox Item by ComboBox Item

  1. #1
    Registered User
    Join Date
    02-07-2016
    Location
    erwer
    MS-Off Ver
    2013
    Posts
    8

    Question Select Listbox Item by ComboBox Item

    Hi
    I have 3 dependent combobox and one listbox in UserForm.


    Combobox item loaded from sheet.


    I want When select comboboxs item , automatically select listbox items by combobox value


    example:
    when I want select in combobox1 value "a"
    and combobox2 value "b"
    and combobox3 value "c"
    Then>Find and select automaticly this value on listbox > Row 8 in listbox selected

    http://www.sharefile.ir/uploads/1512543033.zip

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

    Re: Select Listbox Item by ComboBox Item

    virus detected in file

  3. #3
    Registered User
    Join Date
    02-07-2016
    Location
    erwer
    MS-Off Ver
    2013
    Posts
    8

    Re: Select Listbox Item by ComboBox Item

    what kind of virus
    i sure my file only xlsx and compressed.
    Last edited by atadaliran; 12-06-2017 at 12:44 PM.

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Select Listbox Item by ComboBox Item

    Take a look at a snippet of an example, the rest in attachments:
    Please Login or Register  to view this content.
    Ps: Gosh, you have all on the right, everything hides behind margins !
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-07-2016
    Location
    erwer
    MS-Off Ver
    2013
    Posts
    8

    Re: Select Listbox Item by ComboBox Item

    tanx for helping to me.
    a b c just example
    when any item in 3 combobox selected by user, items selected in list box
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Select Listbox Item by ComboBox Item

    Check if that's what it was about.
    Below one of the amendments (the rest in attachments):
    Please Login or Register  to view this content.
    You can also use Cstr () to transform concatenatings of variables (from tbl_LB(i,j)) into a string, e.g.:
    Please Login or Register  to view this content.
    Maybe even that would be better ?
    Attached Files Attached Files

  7. #7
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    Last edited by Kenneth Hobson; 12-09-2017 at 09:23 PM.

  8. #8
    Registered User
    Join Date
    02-07-2016
    Location
    erwer
    MS-Off Ver
    2013
    Posts
    8

    Re: Select Listbox Item by ComboBox Item

    tanx both of you

  9. #9
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Select Listbox Item by ComboBox Item

    atadaliran: Kindly read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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 excel - last listbox item transfer erasing all listbox items except last item
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2017, 03:48 PM
  2. [SOLVED] VBA To populate listbox with duplicate item by increasing the item quantity
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2016, 07:51 AM
  3. [SOLVED] Pre-select item in listbox
    By PKUK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2015, 08:52 AM
  4. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  5. I want to populate a listbox with a combobox selected item.
    By Bailers in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2014, 06:42 AM
  6. Select Combobox Item With List Item Select
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2011, 02:40 PM
  7. Select combobox item, display wksheet name in listbox
    By ACOM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2009, 05:31 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