View Single Post
  #10   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee teepee is offline
external usenet poster
 
Posts: 103
Default 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