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?

Alberto Ast;607391 Wrote:
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/sh...d.php?t=168491

Microsoft Office Help

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

"p45cal" wrote:


Alberto Ast;607391 Wrote:
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/sh...d.php?t=168491

Microsoft Office Help

.

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.


Alberto Ast;609270 Wrote:
Thanks... it works but before I rate this post I have a question
what is the difference between below two options?

MatchRequired = true
and
Style = fmStyleDropDownList

"p45cal" wrote:


Alberto Ast;607391 Wrote:
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: 'Combobox list validation - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=168491)

'Microsoft Office Help' (http://www.thecodecage.com)

.



--
p45cal

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

Microsoft Office Help