PDA

View Full Version : Solved: combo box entry



benong
09-30-2010, 01:02 AM
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
09-30-2010, 01:09 AM
Set the Style property to 2 - fmStyleDropDownList

benong
09-30-2010, 02:00 AM
Dear Xld,

many thanks for your guidance :)