Combobox that is a dropdown menu only and does not allow user entry

[gautammalkani]

Hi

i created a combobox that has 8 values. however, I do not want the user to input their value on the combobox and I want to keep a dropdown menu (that is why i didnt go with a listbox). Please let me know if there is a way to do this.
Thanks for your help

Regards

Gautam


P.S Below is my attached code

Private Sub ComboBox1_Change()
Dim i As Single
Dim MyArray(8)
ComboBox1.ColumnCount = 8
For i = 0 To 7
MyArray(i) = i + 1
Next i
ComboBox1.List() = MyArray
End Sub

 

[Zathras]

Assuming you're using the combobox from the Control Toolbox, set the "MatchEntry" parameter to True.

 

[fredericofonseca]

set property "style" = 2 - fmStyleDropDownList

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com