How do I test the value of a listbox that I have in a cell? "row" is a running variable inside a do while loop.
Range("row,2").Validation _
.Add xlValidateList, xlValidAlertStop, xlBetween, "=$O$4:$O$7"
If Range(row, 2).Value = "Plate" Then
Cells(row, 9) = Cells(row, 5) *...