title: VBA swap words in a string
body: <p>In VBA I've made an userform. It contains multiple text boxes in which the user can write text. In one text box the user is supposed to type in his last name. I've made a variable called <code>lastname</code> and then did <code>lastname = LastnameBox.Value</code>. </p>
  
  <p>My question is:<br>
  If someone for example types <code>de Vries</code>, how can I change this in <code>Vries, de</code>. Or if someone types <code>van de Voort van Zijp</code>, I need to change this in <code>Voort van Zijp, van de</code>. </p>
  
  <p>How could I make this possible in VBA? </p>