title: Change display in the comboBox and make it a different text when input it in the cells worksheet?
body: <p>I need help,
  how to display in the list combobox with (units)² and when submit it to cells it will be (units)^2 ?</p>
  <p>I want the solution code, please</p>
  <p><a href="https://i.stack.imgur.com/Q1hES.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q1hES.png" alt="enter image description here" /></a></p>
  <p>here is the code that I use:</p>
  <pre><code>Private Sub Label9_Click()
  
  Set Luas_Aja = Worksheets(&quot;Sheet2&quot;)
  
  Luas_Aja.Cells(2, 1) = Nilai
  
  Luas_Aja.Cells(3, 1) = SatIn
  
  Luas_Aja.Cells(4, 1) = SatOut
  
  End Sub
  
  
  Private Sub UserForm_Initialize()
  
  With Me.SatIn
  
  .AddItem &quot;km²&quot;
  
  .AddItem &quot;hm²&quot;
  
  .AddItem &quot;dam²&quot;
  
  .AddItem &quot;m²&quot;
  
  .AddItem &quot;dm²&quot;
  
  .AddItem &quot;cm²&quot;
  
  .AddItem &quot;mm²&quot;
  
  End Sub
  </code></pre>