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?

 

[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

.