title: navigate through defined values in cell with arrow key
body: <p>I've programmed before but I'm new to <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged 'vba'" rel="tag">vba</a> so please help me. </p>
  
  <p>I want to have a user select a cell (any cell in a column) in a worksheet and then he/she should be able to press the "UP" or "DOWN" arrow keys to navigate through values. </p>
  
  <p>It is similar to a drop down menu.</p>
  
  <ol>
  <li>For example I would have predefined values such "STOP","GO","START".</li>
  <li>When the user selects the cell and hit the up arrow key once, the value of the cell changes to "GO", hit the arrow key again, the value changes to "STOP", and so on .... </li>
  </ol>
  
  <p>thank you any help!</p>