title: How to pass value of ComboBox in userform to macro
body: <p>I want to pass a value selected by user to be displayed in MsgBox. I write the following code but its display nothing. </p>
  
  <pre><code>Public Sub CommandButton1_Click()
      SelectedCity = Me.ComboBox1.Value
      DistSystem
  End Sub
  
  Sub DistSystem()
      MsgBox (SelctedCity)
  End Sub
  </code></pre>