Excel VBA to generate pop-warning

I am trying to creat a pop-up warning via VBA in the attached file.

In the attached file,

If the type is "training" and Team is selected, show a pop-up warning to leave the Team blank

If the type is "work" and the team column is blank, show a pop-up warning to select the Team

highlighted cells are incorrect in this example