title: Populate dynamic dropdown in Excel form with VBA
body: <p>I have a dropdown on an Excel form which I want to populate with items listed in sheet "OR", however I need only unique entries from this dynamic list &amp; then populate the dropdown.</p>
  
  <p>Have searched many blogs, suggesting named ranges as Rowsource property, but my list have duplicate items &amp; is dynamic.</p>