Could not get the Column property. ComboBox

[andols]

Hi,

I have a problem with a ComboBox, I fill the listbox with data (two cloumns, name and identifier) and the user shall choose one of the post in the Listbox.

But if the user print something else and press GO I wold like to be able to pick up that and exit the sub.

Some thing like this

If cboOrt.Column(2) Is Nothing Then
 MsgBox "Någonting gick snett, orten hittades inte"
 Exit Sub
 End If

But when I come to that line I get

<Could not get the Column property. Invalid property array index.

I dont want to make the ComboBoxnote "writeable" because the user should be able to write and the listbox "MatchEntry".

Thanx
Anders Olsson

 

[BobRodes]

I'm unfamiliar with any of the functionality that you describe in the ComboBox that I'm familiar with. Are you sure you're talking about a VB6 ComboBox?

HTH

Bob

 

[andols]

No,

I am sorry. I posted in wrong forum. I am working in VBA.

Thanx for your response,

Anders