title: Excel VBA create a button beside cell
body: <p>for my question I would like to create a button beside the cell that is not NULL or "". The caption for the button must follow the value in the cell beside.</p>
  
  <p>For example:</p>
  
  <ol>
  <li>I typed 'EMPLOYEE' in <code>Range("D3")</code></li>
  <li>I want the macro to create a button named "EMPLOYEE" in the <code>Range("C3")</code></li>
  <li>However I want the macro to be dynamic so that every time I type in the value in the column 'D', the cell on the left side - <code>C3</code> will comes out a button.</li>
  </ol>
  
  <p>Therefore, I've figured out that I needed to code for the <code>CommandButton</code> manually is that right? </p>
  
  <p>Nevertheless, million thanks in advance for all.</p>