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
172 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)
Comment Utility
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 500 total points
Comment Utility
I had the wrong property. Set the Style property to DropDownList.

Kevin
0
 
LVL 81

Expert Comment

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

Kevin
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel - Increse columns in range by 5 6 20
Create a loop to find all instances of a string 6 28
TT Status Chang 3 29
onOpen 14 38
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now