Solved

Excel 2003: Combobox: Invalid Property Value

Posted on 2010-11-21
2
813 Views
Last Modified: 2012-05-10
If I make a combobox on a form. Set "Match Required" = True for that combobox and try to put an invalid value in the combobox I get the following message...

"Invalid Property Value".

This is not a intuitive message and if you have ever had multiple comboboxes on a form, the user won't know which one has the invalid entry

Is there a way to change this message? (i.e. "You have entered an invalid name in the name combobox, please select a name from the dropdown
0
Comment
Question by:ouestque
2 Comments
 
LVL 9

Accepted Solution

by:
Tom earned 500 total points
ID: 34184878
instead of forcing the combobox matching, Set the property to false

Check the 'change' event of the combobox  .matchfound
if the box's Text property matches with any element,

if it doesn't, send a custom msgbox and select a default value.

0
 

Author Closing Comment

by:ouestque
ID: 34187332
Cool. I didn't know there was a .matchfound event. Thanks!
0

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.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
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…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

830 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