'Event controls on Gender combo box
private Sub cboGender_DropDown()

'cboGender.Locked = true
'Elements in the combo box
With cboGender
.List(0) = "Female"
.List(1) = "Male"
End With

End Sub




as the code above, i wanna prohibit users from typing words into combo box and limit them to choose either male or female, but the cboGender.Locked doesn't help. How to solve? Or do i use the wrong event procedure?