title: Referring to cell relative to a ActiveX commandbutton VBA
body: <p>I have a lot of ActiveX command buttons on a lot of different worksheets in Excel. </p>
  
  <p>When any of the buttons is clicked i want to put a string in the cell next to the button.  </p>
  
  <p>So far this has been quite bothersome as i can't ask the <code>TopLeftCell</code> of the button as with a <code>Form control</code> button, only the <code>Top</code> and <code>Left</code> values of the control. It's not trivial to transform these to a Row and Column since there are a lot of varying cell heights/widths in every sheet. </p>
  
  <p>I want to prevent hardcoding a cell position in every <code>button_Click()</code> so i can move the button around without problems, modify the sheet,... and so i don't have to change the code of every single button when suddenly the text has to appear 2 cells next to the button instead of 1 cell.</p>