OneDrive Link:
Microsoft services

I have attached a link to OneDrive for the file. The file comes from Nsutradhar - Excel Tutorials.

I have changed the code to work on the actual workbook I am using, but the example accomplishes the same thing. The final product has 34 columns and I have it coded to just show the first four columns of the sheet in the listbox. Columns further up would show up in the UI as check marks showing it has met the criteria. For example, in the workbook attached, you search for "computer" and it shows in the listbox, in the datasheet, under Column ABC there is an "X" for computer. I was trying to have an IF statement that would match the value from TextBox1 and if there is an "X" in ABC, then the CheckBox will tick. I am pretty new to arrays and it throwing me off. Any help would be appreciated.