title: Format specific text within a cell with VBA?
body: <p>When I use Excel it allows me to set specific words within a cell to <strong>bold</strong> or <em>italic</em> or even change the text size.</p>
  
  <p>Is there a way of doing this in VBA?</p>
  
  <p>I have two cells with text. One cell contains a list of words which I separated into an array. The other cell contains a few sentences.</p>
  
  <p>I want to write a macro that highlights all words from cell 1 in cell 2.</p>
  
  <p>My idea was to use the array and InStr to search for the position of my words in cell 2. Once found I wanted to split cell 2, format one word an put everything back together.</p>
  
  <p>Maybe this is possible via Word?</p>