Try this...
![]()
Sub CheckAndContinue() If InStr(1, Range("I2").Value, "Net", vbTextCompare) = 0 Then MsgBox "Condiotion does not match in I2 Cell", vbInformation, "Invalid Text" Exit Sub End If 'Your Code Goes Here..... End Sub
Try this...
![]()
Sub CheckAndContinue() If InStr(1, Range("I2").Value, "Net", vbTextCompare) = 0 Then MsgBox "Condiotion does not match in I2 Cell", vbInformation, "Invalid Text" Exit Sub End If 'Your Code Goes Here..... End Sub
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks