ComboBox questions

[Barguast]

I have a few questions regarding the ComboBox in VBA. Each item in the list has a unique key, and I want to use this to set the initial selected item in the combo. How would I do this? Obviously the following line of code won't work, but it ought to give a good idea of what I'm trying to do:

cboNameList.SelectedKey = "#12"

Something like that, which'd select whichever item has the key '#12'. Is this possible?

Thanks

[trisuglow]

I think you're going to have to loop through the combo's list looking for the key then do something like cboNameList.List(i).Selected = True (not sure about the syntax - I'm typing this from memory)

[Hack]

VBA question moved to Office Development.

[zaza]

If the key is actually the Key property a la VB6 (listview etc), then you can just refer to it like you would an index:

Combobox1.listitems("itemkey1").text

or something of the sort.
However, I think that's only the case if you add in the Windows controls - the normal combobox works in the same way as a listbox, using the Additem method. Here, each item doesn't have a key property. So if it is something that you've set yourself, then you may have to be a bit more specific as to what you mean by "key". Do you just mean that the text of the item is unique?

zaza