+ Reply to Thread
Results 1 to 3 of 3

Search Data using Combobox Textbox and Listbox

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Solid State
    MS-Off Ver
    Microsoft Office 29Millions (all)
    Posts
    3

    Unhappy Search Data using Combobox Textbox and Listbox

    I won't lie, I've been racking my brains to get around this.

    I would like this srchusrfrm.jpg userform to be used in this way;

    Combo Boxes - List headings of column (so out of 12 you can have up to three choices)
    Text Boxes - In conjunction with the above outlined criteria, to search defined column, with textbox value
    Search - actually searches active worksheet
    ListBox - Displays results
    Select - once highlighting the results it opens another Userform to allow the data to editted
    Cancel - Saves workbook and closes userform


    All the code I've wrote, found, researched and used have not seemed to have worked. I have even tried to macro the Filter system, but there are still problems. Either it only works with the combo box or just the text or the text populates the list box... I just can't seem to get my head around it. >.<

    Unfortunately I can not attach the file as it is too big, all help is appriciated, Thank you in advance.
    Last edited by Adrastia; 08-15-2012 at 10:14 AM.

  2. #2
    Registered User
    Join Date
    08-15-2012
    Location
    Solid State
    MS-Off Ver
    Microsoft Office 29Millions (all)
    Posts
    3

    Re: Search Data using Combobox Textbox and Listbox

    I was tyring to think outside the box today and changed it up
    Please Login or Register  to view this content.
    This now finds automatically whilst typing into the search box but will only come up with one result;
    for Example
    Column C has peoples First Names; Scott, Frances, Ruth, Rohan, Frank, Rufus
    If I type "Ru" into textbox1 it will filter and only Ruth will show instead of Ruth and Rufus

    Any Idea how to address this issue?

    Also, how can I get the List box to update with the information on the sheet after it is filtered?

  3. #3
    Registered User
    Join Date
    08-15-2012
    Location
    Solid State
    MS-Off Ver
    Microsoft Office 29Millions (all)
    Posts
    3

    Re: Search Data using Combobox Textbox and Listbox

    In the end I have given up on the listbox, I just couldn't figure out how to update it with just the filteredcells.
    If anyone was interested my finished code was:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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