+ Reply to Thread
Results 1 to 5 of 5

Help: Adding additional search features ComboBox/DropDownList to search specific columns

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    54

    Help: Adding additional search features ComboBox/DropDownList to search specific columns

    Hello,

    I am trying to add additional search features using the combobox to allow user to select which columns they want to search in.

    NewSearch.jpgData.jpg

    Here is my current code:

    Please Login or Register  to view this content.
    excel file:
    ExcelHelp TMS.xlsm
    Last edited by khhoa; 11-25-2014 at 01:53 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help: Adding additional search features ComboBox/DropDownList to search specific colum

    If you want 'TITLE' to be default when the form opens add this to the initialize sub after the code to populate the combobox.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    54

    Re: Help: Adding additional search features ComboBox/DropDownList to search specific colum

    Thanks Norie.


    Do you know how I would be able to go about having the combobox to search the value in textbox1?

    I currently have the textbox1 to auto populate title column "A".

  4. #4
    Registered User
    Join Date
    11-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    54

    Re: Help: Adding additional search features ComboBox/DropDownList to search specific colum

    Please help, Thanks.

  5. #5
    Registered User
    Join Date
    11-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    54

    Re: Help: Adding additional search features ComboBox/DropDownList to search specific colum

    Still need help with this searching feature

+ 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. Replies: 5
    Last Post: 11-16-2014, 11:04 AM
  2. Replies: 1
    Last Post: 10-04-2014, 12:57 AM
  3. [SOLVED] search for text in colB, starting with next row search for 1st occurrence of specific #
    By roothog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2012, 10:39 PM
  4. Search as you type, look-up, auto sort and other features
    By yashkapoor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 03:20 PM
  5. Search for 3 specific columns and copy
    By csynic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2011, 04:43 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