• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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

Hi Experts,

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

Thanks
0
indyng
Asked:
indyng
  • 3
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
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
 
zorvek (Kevin Jones)ConsultantCommented:
I had the wrong property. Set the Style property to DropDownList.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
The MatchRequired property does not work well in Excel.

Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now