Creating Error popup button

[Raj2003]

Hi everyone,

I need help in creating popup button for certain error...
Error : If cell value is 1 for 2 consecutive cells in a particular column.. error message button should popup

Regards
Keen learner

 

[Raj2003]

Try this:
Not sure why you want it this way but here is what you were trying to do.

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 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.

 

[Raj2003]

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,

The values in Column A will always be in Pair

 

[My Aswer Is This]

Not sure why someone is marking this answer as solved and it appears as if one of my postings have been removed.
So:
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Raj2003]

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,

can anyone please help me with the problem here....