Results 1 to 11 of 11

listbox of combobox2 depends on value choosen from listbox of combobox1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2012
    Location
    beirut
    MS-Off Ver
    Excel 2007
    Posts
    215

    listbox of combobox2 depends on value choosen from listbox of combobox1

    I have a userform contain two comboboxes , one for names and second for marks, the RowSource of combobox Names is column A , the RowSource of Combobox Marks is second row from column B to M.
    I want a code in commandbutton1: if I choose the name from combobox Names like George , I want List of combobox Marks show just the head column where marks exist ( Mark A, Mark C , and Mark G for George names and Mark B , Mark D ,Mark J forg Elie names ) , and if I choose name doesn't have any Marks like Helen or Philip I want combobox Marks show all Marks names in second Row ( from Mark A , Mark B … till Mark L)

    see attached file

    Thanks in advanced
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] userform combobox2 does not have unique values and will not fill listbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2013, 12:22 PM
  2. Disabling dependent combobox2 until selection is made in combobox1
    By newqueen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2013, 11:25 AM
  3. [SOLVED] items in combobox2 depending on combobox1
    By minifreak in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2012, 10:52 AM
  4. Using Entry of ComboBox1 to decide the entries of ComboBox2 using Excel Columns
    By sungodking in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2012, 08:11 AM
  5. Combobox2 dependent on Combobox1
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-19-2011, 10:10 AM

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