Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can the value of a list box control in Excel be limited to only the values in the list?

Posted on 2007-11-23
3
Medium Priority
?
183 Views
Last Modified: 2013-12-25
Hi Experts,

How can the value of a list box control in Excel be limited to only the values in the list?

Thanks
0
Comment
Question by:indyng
  • 3
3 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 20341580
Assuming you are populating the list box control with values then those values will be the only ones that can be selected. A list box control does not allow values to be entered that are not in the list.

If you are talking about a combo box then there are two flavors. The Forms combo box only allows selection of an item in the list. An ActiveX control will allow entry of values not in the list unless the MatchRequired property is set to True.

Kevin
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 2000 total points
ID: 20341586
I had the wrong property. Set the Style property to DropDownList.

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 20341596
The MatchRequired property does not work well in Excel.

Kevin
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question