Excel VBA Left function for 2 different cells

[NLU_VBA]

Hello,

In an Excel sheet I want to compare the 4 first digits in 2 different cells C5 and C9, and make sure that these 4 digits are identical in both cells. Otherwise a message "Please review your text" must be displayed.
I guess that the LEFT function must be used.

As I am a beginner in VBA, can someone help me please?

 

[dreid1011]

Perhaps something like this:

Private Sub CheckFour()
If Left(Range("C5"), 4) <> Left(Range("C9"), 4) Then
    MsgBox "Please review your text."
End If
End Sub

Left function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[Joe4]

How are these values entered into cells C5 and C9?
Is it done manually?

When do you want this comparison to run?
As data is being manually entered in cells C5 and C9?
Or do you want this comparison to be run at some other time/event?

 

[NLU_VBA]

How are these values entered into cells C5 and C9?
Is it done manually?

When do you want this comparison to run?
As data is being manually entered in cells C5 and C9?
Or do you want this comparison to be run at some other time/event?

In C5 values are entered manually; in C9 there is a dropdown menu, but the 4 first digits in all options have the same format as those that need to be entered in cell C5

 

[NLU_VBA]

Perhaps something like this:

Private Sub CheckFour()
If Left(Range("C5"), 4) <> Left(Range("C9"), 4) Then
    MsgBox "Please review your text."
End If
End Sub

Left function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

Many thanks!

 

[Joe4]

So, are you all set now, with the code that dreid1011 provided?
Note that you have to run that code manually.

If you want it to run automatically when entries are made to cells C5 and C9, that can be done.

 

[NLU_VBA]

So, are you all set now, with the code that dreid1011 provided?
Note that you have to run that code manually.

If you want it to run automatically when entries are made to cells C5 and C9, that can be done.

Yes, I am! It works well!

 

[Joe4]

OK, then I will mark it as the solution (note that you can do that too in the future -- see here: Mark as Solution)

 

[dreid1011]

Many thanks!

You're welcome, and happy to help.