+ Reply to Thread
Results 1 to 3 of 3

Multiple listbox populating problem

  1. 09-13-2017, 09:11 AM #1
    rukman is offline
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Multiple listbox populating problem

    Hi friends & gurus:-

    Here I attached my file...


    in this I had a user form. it had 3 list box...


    1. level

    2. area

    3. staff details


    level listbox populated done. in the list when I double click the value listbox2 is populate the area of level


    eg: - if listbox1 = nb2

    listbox2 need to populate (Reception / AE / SCAN) FROM "AREA" SHEET.



    AFTER IT POPULATE I DOUBLE CLICK THE VALUES IN LISTBOX2. EG:- SCAN...... LISTBOX3 POPULATE THE EQUALLENT VALUES FROM "STAFF DETAILS" SHEET.. EMP NO & Name (multiple column)...



    Please help me
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-13-2017, 12:14 PM #2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,255

    Re: Multiple listbox populating problem

    One way to do it.
    Try NB2 - CENTER CORE
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
  3. 09-13-2017, 12:51 PM #3
    rukman is offline
    Registered User
    Join Date
    05-03-2011
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Multiple listbox populating problem

    Thanks its workinggggggg.... its very useful to my future implementation... thanks guru
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populating a Multicolumn ListBox with Multiple Ranges
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2016, 03:53 PM
  2. [SOLVED] Populating a listbox; multiple records
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-12-2016, 03:47 PM
  3. [SOLVED] Listbox AutoFiltering problem when Populating A UserForm
    By u3rick in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-15-2015, 11:45 PM
  4. [SOLVED] Populating Listbox Colums from multiple sources
    By AndyE in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 07:38 AM
  5. Multiple combo boxes - listbox populating
    By burgerboy2k6 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2007, 08:08 AM
  6. Problem: populating listbox items
    By ilyaskazi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2005, 07:22 AM
  7. [SOLVED] Populating a listbox will a certain cell on multiple worksheets in the activeworkbook
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 09:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1