So you need to do something similar to what the INDIRECT function does with cells. I don’t know if that is possible in VBA, but how about using an array instead of the 3 variables ABC1001, ABC1002 and ABC1003 ?
Something like this:
<pre>Dim ABC100(1 To 3) As String</pre>
You could then do something like this to pass the desired text to the Company variable.
<pre>Company = ABC100(ComboBox1.ListIndex + 1)</pre>
<pre>Company = ABC100(Right(ComboBox1.Text, 1))</pre>