Macro for Message Pop-up

rhmkrmi

Board Regular
Joined
Aug 17, 2012
Messages
246
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.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

rhmkrmi

Board Regular
Joined
Aug 17, 2012
Messages
246
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

Board Regular
Joined
Aug 17, 2012
Messages
246
Hi Rick, Would you get back to me on this or do I log a new thread? Thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,334
Messages
5,413,847
Members
403,504
Latest member
rosebo

This Week's Hot Topics

Top