Pop Up Appears Twice After Running Initially

I am looking to show a pop up box only once when particular options are selected from dropdowns (1,1,1). However, the initial Hello message box appears for a second time following the second macro.

I have attached an example Excel doc to help explain the issue. If you select 1 from all the dropdowns the issue will become clear. Only want the Hello message to appear initially.

Thanks for your response. This does work. However, it stops the other macros running. I have other Select Case functions for alternative options i.e. when '2' is selected from B3 different rows hide and display (I didn't include this in the Developer).

Any other thoughts?

Don't put the msgbox in the case "1" because then it will always trigger when cell B1 = 1
if you put a separate test to see if B1 cell is the changed cell then it will only show if you change cell b1

Please Login or Register  to view this content.

I also changed the hiding of rows a bit, but that is more a cosmetic thing to make the code easier to read.