Private Sub ListView1_Click()
strCondition = ListView1.SelectedItem.Text & " = ''"
With ComboBox1
.SetFocus
.Value = strCondition
.SelStart = Len(ComboBox1.Value) - 1
End With
End Sub
Private Sub ListView1_Click()
strCondition = ListView1.SelectedItem.Text & " = ''"
With ComboBox1
.SetFocus
.Value = strCondition
.SelStart = Len(ComboBox1.Value) - 1
End With
End Sub