title: How to update a userform label once range selected via refedit
body: <p>I have a userform with 2 refedit boxes. They both allow the user to select a cell. I have a label underneath each refedit that i would like to show the text of a specific cell on that row (not necessarily the selected cell), I guess it would be something like:                                                      </p>
  
  <pre><code>Range("D" &amp; Range(Refedit1.Value).Row)
  </code></pre>
  
  <p>or similar (Any suggestions/improvements on this appreciated)</p>
  
  <p>My question is: how do I get this to update every time a new cell is selected? I've read that refedit is buggy and can break easily if it is made too complicated.</p>