Hi, can anyone help me with the following?
I have a spreadsheet where if the text equals either "AV_EXC" or "AV_INC" or "ADJ_EXC" or "ADJ_INC" in cell range C39:D64 then I want the following message to appear "Enhanced SPL is only available for weeks 1 to 26, please check the dates".
Just for completeness, I already have the following code applied to the worksheet for some other actions
Thanks in adavnce
I have a spreadsheet where if the text equals either "AV_EXC" or "AV_INC" or "ADJ_EXC" or "ADJ_INC" in cell range C39:D64 then I want the following message to appear "Enhanced SPL is only available for weeks 1 to 26, please check the dates".
Just for completeness, I already have the following code applied to the worksheet for some other actions
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("I11") < Range("Z34") Then
MsgBox "There are not enough Enhanced SPL weeks available for Parent 2, please check your calculations"
End If
If Range("P21") < Range("I30") Then
MsgBox "There is not enough Statutory Pay available for all of the Enhanced SPL weeks for Parent 2, please check your calculations"
End If
If Range("P23") < Range("I32") Then
MsgBox "There are not enough 'Statutory Pay Only' weeks available for Parent 2, please check your calculations"
End If
If Range("P24") < Range("I33") Then
MsgBox "There are not enough Unpaid SPL weeks available for Parent 2, please check your calculations"
End If
End Sub
Thanks in adavnce