Add update Make anonymous Delete question I'm creating a form and I'm using the current code as part of it to find numbers in the worksheet. If it finds the number 25, it sees it as finding number 5 as well, even if it is not in the range of cells. How do I avoid this?

For Each theCell In Worksheets("Lunch Reservations").Range("N5:N38")

For Each ctrl In UserForm1.Controls

If TypeOf ctrl Is msforms.ToggleButton Then

If InStr(theCell, ctrl.Caption) Then

ctrl.BackColor = vbRed

End If

End If

Next ctrl

Next