title: Excel VBA: Get cell at center of shape
body: <p>I have a few shapes (or more specifically, dropdown lists) which are roughly aligned to individual cells and would like to know for each shape which cell lies underneath.</p>
  
  <p>I know there are the following members:</p>
  
  <pre><code>Dim dd As Shape
  dd.BottomRightCell
  dd.TopLeftCell
  </code></pre>
  
  <p>to get the bottom right or top left cell under the shape, but since the shapes are manually placed and not always properly aligned (sometimes the bottom right corner touches the row beneath, sometimes the top left corner the row above, ...) both values can not be trusted.</p>
  
  <p>I would like to know which cell I get when I look at the center of the shape. Is there a way to get this information?</p>