Question regarding this example from book Power Programming with VBA Excel 2019, which portrays matching items in a UserForm ListBox to the text in a TextBox, then filtering the ListBox accordingly.
It seems that after transferring the values of the DataBodyRange of the excel table "tblContacts" to a variant/dynamic array variable, the subscripts of the array elements are defaulting to Base 1 instead of Base 0, seemingly without an explicit Option Base 1 instruction.
Using function LBound in the immediate window verifies Base 0. Am I missing something?
Bookmarks