Macro for Message Pop-up

[rhmkrmi]

Hi, Can you please help me with a macro that pops up one message when we go into a sheet and another when we move out of that sheet or close the workbook?

In case this is too hard, I can use just the one message.

I also need help adding this macro to some more that already exist in the sheets.

Thank you.

 

[rhmkrmi]

Hi Rick,

In range A1:A20 there are drop-down lists and the user can select “Activate” from the list.

In range B1:B20 there are drop-down lists and the user can select “Home” from the list.

If the user selects “Activate” in A1 and “Home” in B1, the pop-up should appear. Also, if the user selects “Home” in B1 and “Activate” in A1, the pop-up should appear.
This applies to all rows in A1:A20 and B1:B20.
The values "Activate" and "Home" should not be selected or exist in the same row next to each other. As soon as this happens, I need the message to pop up.

I do not want it to check when the worksheet activates and/or deactivates.

Please let me know if I need to be more specific.

Thank you.

 

[rhmkrmi]

Also, can I ask how I can make this code to work in range B1:B20 instead of just B20 please? Thank you.

If Cells(1, 2).Value = "" Then
MsgBox "Cell B1 requires user input"
Cancel = True
End If

 

[rhmkrmi]

Hi Rick, Would you get back to me on this or do I log a new thread? Thank you.