title: Using Substring and IndexOf methods in VBA
body: <p>I have the following code:</p>
  
  <pre><code>Dim Op1 As String
  Dim Op2 As String
  Dim operatore As String
  operatore = ComboBox1.Value
  Op1 = operatore.Substring(0, operatore.IndexOf("&lt;")).Trim()
  Op2 = operatore.Split("&gt;")(1)
  </code></pre>
  
  <p>When I compile, I get the error: "Qualifier not valid" refered to variable "operatore". How can I fix it?</p>