title: Clear Text boxes within a Multipage Control on Userform
body: <p>I am working on a school project while learning vba for the first time. The project is built around a wedding planning worksheet. I plan to lockdown the worksheet so that formulas and formatting don't get broken by the user (my fiance would find a way). In order to do this, I am building a userform that collects the data via text boxes on different pages of a multipage control.</p>
  
  <p>This example only has one page, but it will show others like "Apparel" later:
  <img src="https://i.stack.imgur.com/chb2K.png" alt="enter image description here"></p>
  
  <p>I currently have the following code on _Click for the "Clear" button.</p>
  
  <pre><code>Dim C As Control
  
  
  For Each C In frmExpenses.Controls
      If TypeName(C) = "TextBox" Then
          C.Value = ""
      End If
  Next C
  </code></pre>
  
  <p>This effectively clears the data from the text boxes. However, I want to be able to clear the data on ONLY the active page on the multipage. For example if there is later a tab called "Flowers" and it's the active tab, I want to leave the data on "Apparel" and clear the data from "Flowers."</p>
  
  <p>I tried being as thorough as possible above. Let me know, if you need clarification on something.</p>