title: Data validation list, combo box, or active X combo box in Excel 2010?
body: <p>Started with a data validation list and I like that it is in the cell where I want the data to appear. Tried combo box and active X combo box and don't like that they do not reside in the cell. This is very different than Access. This is what I am trying to accomplish:</p>
  
  <p>My named range (Employee) is <code>A4:C100</code>, 3 columns, with headings <code>Title</code>, <code>MI</code>, and <code>LN</code> on a sheet named "Emp".</p>
  
  <p>My form location is C6. I wanted to be able to show 3 columns and end up with data from the three columns. For example, Officer J. Doe.</p>
  
  <p>Currently I am using data validation list entering data into one column as Doe, J., Officer and it works. The list can be long and I will need it to be in alphabetical order. </p>
  
  <p>Is this the best way or am I confused with combo box and active X combo box?</p>