Determine Selected Item in a (Userform’s) ComboBox

A1. When something is selected, ListIndex property is greater than -1.
A2. If Value property is not empty, then user has typed something in (check with "If IsEmpty(cmb.Value)...").
A3. Set "AutoWordSelect=True".

Please Login or Register  to view this content.

I've tried both: If ComboBox1.ListIndex > -1 Then MsgBox ComboBox1.Value

And: If ComboBox1.AutoWordSelect = True Then MsgBox ComboBox1.Value

But if I type in a single letter, then ListIndex > -1 and AutoWordSelect = True and ComboBox1.Value is not empty.

For example, there are a number of items in my list which start with a letter 'L'. And if I type the letter 'L' I get (I assume) the first item on the list which begins with a letter 'L'.

What I want to know is:

Q1: Did the user select an item from the list?

Q2: If the user types in a name, is the user done typing?

Q3: Is Combobox1.Value an item in the ComboBox1.list?

Here is what happens.
A1. When you set AutoWordSelect to True, then when user types something in and that "something" matches with any of items, then ListIndex becomes greater than -1 (i.e. 0, 1,2 etc.). Thus ListIndex becomes greater than -1 when a) user typed something and that combobox contains that "something" and b) when user explicitly selected item from drop-down.
A2. Actually, incorrect question. There's no such definition "done typing". Even empty combobox is "done typing".
A3. "Combobox1.Value" is the same for "Combobox1.List(Combobox1.ListIndex)".

Thanks! That is precisely what I needed!