Hi everyone,Try this:
Not sure why you want it this way but here is what you were trying to do.
VBA Code:Private Sub Worksheet_Change(ByVal Target As Range) 'Modified 12/17/2020 4:32:32 PM EST If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub If Target.Column = 1 Then If Target.Value = Target.Offset(-1).Value Then MsgBox "Different Pairs Found" & vbNewLine & "In the cells above" End If End Sub
Hi der,Hi everyone,
Let me describe my issue again clearly with proper Screen Shots.I have Order ID in Column A & column B is extracted value from Column A using =RIGHT() FORMULA. Column C is having countif() formula. So what i need is : If column B gets two different Orders , Error msg box should popup.
View attachment 28239
Hi der,Hi everyone,
Let me describe my issue again clearly with proper Screen Shots.I have Order ID in Column A & column B is extracted value from Column A using =RIGHT() FORMULA. Column C is having countif() formula. So what i need is : If column B gets two different Orders , Error msg box should popup.
View attachment 28239