title: How to Add labels & text box based on different sheets?
body: <p>I want to add labels &amp; text box based on particular sheet.</p>
  <p>I have created one user form where in its drop down I have written vba code to get sheet names inside the combo box now in particular sheet the sheet contains drawing number and various name of the parameters like diameter 1, length 1 etc &amp; dimensions of the parts.</p>
  <p>Now the user form which I am trying to make is to add the data on particular sheet (based on the selection of sheet in combo box). so that one has to not to go on each sheet and data manually.</p>
  <p>I am not getting proper idea how to write vba code that add/reduces the labels &amp; textbox based on the sheet name selection done in the combo box (means noob sheet contains Diameter1,Diameter2,length1, length2 while spring sheet contains numbers of turns, Diameter of wire, Compression length, Expansion Length etc) this are all varying list of parameters which I want to display in the Labels and In the textbox user will enter data and that data will particularly go into the particular sheet.
  The user will select the sheet name in which he wants add data then all the list of parameters will be displayed in the labels and after selecting add button I will add to particular sheet.</p>
  <p>pl. find in the attached images where I am showing my sheet &amp; my user form.</p>
  <p>If any body help me that how to do such thing through vba code it would be great help.</p>
  <pre class="lang-vb prettyprint-override"><code>Private Sub UserForm_Initialize()
  
      Dim A As Long
      Me.ComboBox1.Clear
      For A = 1 To Sheets.Count
          Me.ComboBox1.AddItem Sheets(A).Name
      Next
      Me.ComboBox1.Value = ActiveSheet.Name
  End Sub
  </code></pre>
  <p>Sheet name having spring data<br />
  <a href="https://i.stack.imgur.com/Os9Sx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Os9Sx.png" alt="Sheet name having spring data" /></a></p>
  <p>Sheet Name Having noob data<br />
  <a href="https://i.stack.imgur.com/F271r.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F271r.png" alt="Sheet Name Having noob data" /></a></p>
  <p><a href="https://i.stack.imgur.com/R1e2l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R1e2l.png" alt="User form image" /></a></p>