title: How to dynamically get the value of current multipage tab value?
body: <p>Community, I am currently hiding my tabs on my userform multipage except for the current tab.  The user can click buttons to switch back and forth between pages.  Some buttons share sub routines.  When a user clicks a button, it hides the previous tab once the new tab has been selected.  I suppose this is a dual question.</p>
  
  <p>1) How can I get the previous tab selection value?</p>
  
  <p>2) How can I loop through my tab values?  My objective is to test the current tab caption or value against all the others.  Figured this would be an easy way of hiding them all regardless as to which page and which button calls the subroutine.</p>
  
  <p>Right now I only have this for one tab button...</p>
  
  <pre><code>Sub NewCreditSetup()
      MultiPage1.Pages(1).Visible = True
      MultiPage1.Value = 1
      MultiPage1.Pages(0).Visible = False
      //More code displaying tab...irrelevant
  End Sub  
  </code></pre>