title: VBA Instant conversion of letters to Uppercase upon population of Excel Cell
body: <p>I am looking for a macro that will <em>automatically</em> be activated upon event.</p>
  
  <p>If someone inserts a text value or a value that has text on <code>cell A1</code> <em>once he presses</em> enter and the cell has been populated <strong>if</strong> there is somewhere a <em>lowercase</em> letter it will convert it to <em>uppercase</em>.</p>
  
  <p>However the catch is that it must be automatically without having to fire-up the macro yourself.</p>