Userform combobox question
run time error '-2147024809 (80070057)
could not get the list property. invalid argument.
"Dave Peterson" wrote in message
...
I have no idea what MP.CurrentPosition is and how it fits in, but you may be
able to tie into the Combobox's change event:
Private Sub Combobox1_change()
Dim myVar As Variant
With Me.ComboBox1
If .ListIndex < 0 Then
Beep
Else
'pick out the second column
myVar = .List(.ListIndex, 1)
MsgBox myVar
End If
End With
End Sub
|