title: Using userforms to simulate Excel panes
body: <p>I'm looking for a way to do exactly what the title of this post states: using a userform to simulate a pane. This is for Ms Excel, and should be compatible from the versions 2010 forward.</p>
  
  <p>Removing the userform's border so it has a flat like pane appearance I already know how. My main problem is the size of the userform being what a pane size is: always ajusted to the available excel window screen for this kinda things.</p>
  
  <p>This being: a pane will always have the correct size to ajust to having or not a statusbar visible, having or not the ribbon visible, and so on. This is afected by the displayed items and, not sure on this one, screen resolution.</p>
  
  <p>The sizing of my custom userform to truly simulate a pane is my problem, taking to account what I stated earlier, and that I don't know how to solve, since I can't find documentation that states how to find these mesures. The main one is, no doubt, the height to use.</p>
  
  <p>Thanks!</p>