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
Bookmarks