Combobox list validation

[Alberto Ast]

I have a combobox with a list assigned with

For X = 16 To 30
ComboBox1.AddItem Sheets("Staff").Cells(1, X).Value
Next

but if user type something different it will take it

How do I force it to take only values from the preloaded list?

 

[p45cal]

I have a combobox with a list assigned with

For X = 16 To 30
ComboBox1.AddItem Sheets("Staff").Cells(1, X).Value
Next

but if user type something different it will take it

How do I force it to take only values from the preloaded list?

Set its MatchRequired property to true. At run time by:
ComboBox1.MatchRequired = True
or at design time in the Properties pane for the combobox

 

[Alberto Ast]

Thanks... it works but before I rate this post I have a question
what is the difference among below two options?

MatchRequired = true
or
Style = fmStyleDropDownList

I have a combobox with a list assigned with

For X = 16 To 30
ComboBox1.AddItem Sheets("Staff").Cells(1, X).Value
Next

but if user type something different it will take it

How do I force it to take only values from the preloaded list?

Set its MatchRequired property to true. At run time by:
ComboBox1.MatchRequired = True
or at design time in the Properties pane for the combobox.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=168491

Microsoft Office Help

.

 

[p45cal]

From the help file regarding Style:
fmStyleDropDownCombo: The ComboBox behaves as a drop-down combo box.
The user can type a value in the edit region or select a value from the
drop-down list (default).
fmStyleDropDownList: The ComboBox behaves as a list box. The user must
choose a value from the list.

regarding MatchRequired:
True: The text entered must match an existing list entry.
False: The text entered can be different from all existing list entries
(default).

So it would seem that you don't require Matchrequired=true if Style is
fmStyleDropDownList.