Hello I have this code currently
Sub Check ()
If Cells (i, 8).EntireRow.Font.ColorIndex = 54 then MsgBox "item has been scan"
End If
End sub
However, whenever my other code, that causes the colorindex to change, the MsgBox pops out immediately (too fast). Is there a way to slow it down?
Sub Check ()
If Cells (i, 8).EntireRow.Font.ColorIndex = 54 then MsgBox "item has been scan"
End If
End sub
However, whenever my other code, that causes the colorindex to change, the MsgBox pops out immediately (too fast). Is there a way to slow it down?