Relatively new with VBA and doing my best to learn it. I have a userform which has a listbox. To this I would like to add some type of Match function so that the listbox only displays the rows in which a certain value is displayed. For example, the project ID is displayed in Sheet1 cell B1. In the table, the corresponding project IDs are in Sheet2 column A. I would like the listbox to only show the rows in which the value in Sheet 2 Column A match the value in Sheet 1 cell B1.
Currently the listbox displays all of the rows from the sourced table with only select columns. How can I modify this to include the Match function as described above. Open to other methods as well (i.e. filter, etc).
Sub MRReset With MRForm .ComboBox1.Value = "" .ComboBox2.Value = "" .ComboBox3.Value = "" .ComboBox4.Value = "" .TextBox1.Value = "" .ComboBox6.Value = "" .ComboBox7.Value = "" .TextBox2.Value = "" .ComboBox9.Value = "" .ComboBox10.Value = "" .TextBox3.Value = "" .MRRowNumber.Value = "" End With sn = Sheets("DataTable").Range("A1:O1000").Value sp = Application.Index(sn, [Row(1:999)], Array(1, 7, 15)) 'Referenced from a third party with original source: VBA for smarties: Arrays, Title 6.7.1 End Sub