Hi
sht = Me.ComboBox15.ValueIf Sheets(sht).Cells(i, "A").Value = (sht) Or _
Sheets(sht).Cells(i, "A").Value = productCode Then
Me.TextBox13 = Format(Sheets(sht).Cells(i, "C").Value, "0.00")
I have the above Syntax that looks up a value on a worksheet, it works fine, but I would like to...