+ Reply to Thread
Results 1 to 2 of 2

Display in Listbox,based on combobox select the spare cards history

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Display in Listbox,based on combobox select the spare cards history

    Hi Guys,

    Been knocking myself out with this,
    I have 3 sheets the first Find opens a form that displays driver contact detail also has a list box, the drivers detail is selected by the combobox and works well - back to the list box soon.

    the contact data sheet contains the names of the drivers.

    the spare cards sheet contains a list of driver names - those that have taken a SPARE card - on loan if you like.

    what I'm trying to do is when then form open at the start type in any drivers surname in the combo box - the text boxes will contain all the contact detail and the list box will have either "No drivers spare card history or contain the 7 columns as in the spare cards sheet with the relevant data in it (a drivers name may appear several times in the "Spare Card" history I need to know all the history as per the column headings.

    I've tried a table, vlookup to no avail I know its simple but just cant get my head around it.



    Any help would be appreciated

    In my haste to upload this morning I uploaded the wrong file! sorry - again any help would be appreciated

    If you do happen to have a look at the file just save it and reopen it got a few little problems to work around with a "call statement - just hav'nt had the time
    Attached Files Attached Files
    Last edited by Mikebau; 11-19-2013 at 09:01 AM. Reason: wrong uploaded file

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Display in Listbox,based on combobox select the spare cards history

    Hi Mikebau

    Welcome to the Forum!!

    Try the Code in the attached...
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. Select Combobox and populate Listbox
    By kapoeira in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-07-2013, 06:19 AM
  2. Replies: 2
    Last Post: 12-07-2012, 02:10 AM
  3. Display info in Listbox/Combobox
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2011, 06:50 AM
  4. 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
  5. vba-Select from combobox,display in listbox
    By ACOM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2009, 03:46 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