+ Reply to Thread
Results 1 to 10 of 10

Filter worksheet based on last word of combobox selection

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    Filter worksheet based on last word of combobox selection

    Hi!

    I am currently creating a userform to submit requests with into a existent worksheet as a more efficient solution than the current process. One of the requirements is that people fill in their name in a combobox in the format First letter. Last Name (e.g. J. van der Pol). I currently want to add a commandbutton to the userforms which filters the worksheets for their name. However, because people in the past used different ways to enter their name, it only filters for the exact match.

    E.G. filtering for J. van der Pol, it does not find J v.d. Pol, J Pol or Jordy vd Pol.

    I want to set the filter in such a way, where it only filters for the last word of the combobox input, which in my examples would be 'Pol'.

    Thanks upfront for your help!

    P.S. This is my current code, in which 'Txtaanvrager' is the respective combobox


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Filter worksheet based on last word of combobox selection

    Hi,
    May be:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    Re: Filter worksheet based on last word of combobox selection

    Unfortunately the filter returns no values in the worksheets now... Thank you for the suggestion though!

  4. #4
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Filter worksheet based on last word of combobox selection

    Please attach a sample workbook, so that I can see what I could do.
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    Re: Filter worksheet based on last word of combobox selection

    Sorry I can unfortunately not upload it as it contains sensitive data... is there any way in which I can provide more info?
    Last edited by DanielZig; 08-03-2016 at 08:30 AM.

  6. #6
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Filter worksheet based on last word of combobox selection

    Update this line
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    Re: Filter worksheet based on last word of combobox selection

    Still does not work... I really appreciate the help though!!!

  8. #8
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Filter worksheet based on last word of combobox selection

    It works perfectly for me here. Use only the available names (which are in 'Requests' tab) in the 'Naam aanvrager*' drop down box. I tested using the name 'S. Zuurbier'.

  9. #9
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    Re: Filter worksheet based on last word of combobox selection

    Works now for me as well! I was still working in the sample doc so a lot of names were missing, hence it wasnt working. THanks!

  10. #10
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Filter worksheet based on last word of combobox selection

    I'm glad that I was able to help you.

+ 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. filter and copy filtered data to another sheet based on combobox selection
    By prince82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2015, 11:09 PM
  2. Populating Combobox based on Combobox selection from EXCEL worksheet
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-04-2014, 08:14 AM
  3. [SOLVED] Using Command Button to Open Worksheet Based on ComboBox Selection
    By laura_jean in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2014, 09:23 AM
  4. [SOLVED] UserForm Combobox Value based on Worksheet selection (2007)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2014, 10:52 AM
  5. Replies: 7
    Last Post: 08-06-2013, 02:23 PM
  6. [SOLVED] Based on userform combobox selection find text on worksheet
    By afpPaul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2012, 08:07 AM
  7. [SOLVED] Change Worksheet based on ComboBox selection
    By dagindi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-15-2012, 10:19 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