title: If statements inside MsgBox
body: <p>Does anyone have a way of including if statements inside of a msgbox in VBA? I can’t seem to find a suitable solution by searching… </p>
  
  <p>To explain, let’s say that I have three cells, a1 and a2 and if any of these are empty I want a word to be included in a msgbox. </p>
  
  <p>So I want something like </p>
  
  <pre><code>Sub xx
    Msgbox if a1 = "" include "word one" end if &amp;  if a2="" include "word two" end if
  End sub 
  </code></pre>
  
  <p>I know I can do it with <code>if</code> statements outside of the msgbox, but my problem is a bit larger and would require over 1000 combinations.</p>