0

I am using Visual Basic to build a macro in Excel. I have a comboBox (ActiveX) linked to a range of cells to allow for autocomplete.

I would like the input text to be case and diacritic insensitive.

For example, let's say I am looking for the word "alàlà". I would like this suggestion to come up even if for example the input text is "Alala".

Would anyone have an idea?

Trichophyton
  • 625
  • 5
  • 21
  • Split the string into a character array, then loop through it and apply a lookup table to or regex to each character. Take the result of that and roll it up into a custom equity check. – Comintern Jan 25 '19 at 14:57
  • Thx. I see what you mean, so I guess there is no easier way to deal with it, like a kind of object property to change? – Trichophyton Jan 25 '19 at 15:02
  • This might help create your mapping table.https://stackoverflow.com/a/18123985/4839827 – Ryan Wildry Jan 25 '19 at 18:18

0 Answers0