Solved: combo box entry

[benong]

hi,
i have a combo box with items(apple, orange, banana).
i can select these fruits from the combo box list and the value was display on a worksheet cell.
i also discovered if i do not select a value on the combo box list, and i simply enter any characters in the combo box, that value is also accepted and display on the worksheet cell!
how can i prevent this? i only want the user to select from the combo box list provided.

[Bob Phillips]

Set the Style property to 2 - fmStyleDropDownList

[benong]

Dear Xld,

many thanks for your guidance