Microsoft Office Forums - View Single Post - Search Para No(s). thru Autofilter Combobox

Guessed · 02-23-2021, 08:55 PM

Those constants are all defined in Excel. In Excel these resolve as
xlBeginsWith = 2
xlContains = 0
xlDoesNotContain = 1
xlEndsWith = 3
xlNoFilter = ""

The ComboBox in a VBA userform is essentially the same but when interacting with the application may cause you to use different methods to achieve the same thing. For instance a Range in Excel can be used to populate the .List property of a combobox. Word requires you to convert a Range into an array before you can populate the .List property.