Invalid Property Value Error

  • Thread starter Thread starter LarryP
  • Start date Start date
L

LarryP

Have a form in an Excel file. Have a Control on the form
("ControlX"), default value of which is "". When entering
ControlX, check is performed to ensure a prior control
contains an appropriate value. When exiting ControlX
(i.e., upon AfterUpdate), ControlX value is saved to a
global variable for later use. All this works fine during
the normal sequence of events.

However, if the user returns to ControlX and deletes the
value (as in "Oops, I made a mistake"), and then tries to
go to another control, he gets a "Invalid Property Value"
error message generated by Microsoft Forms (or so I infer
from the Blue Bar on the error message popup).

I've tried a couple of different error-trapping structures
to deal with the fact that something out there in the
background obviously doesn't like a null value in
ControlX, including one that set the value back to ""
instead of Null, but so far no luck, still get the
message. Anyone have any suggestions?
 
It would be VERY helpful if you indicated what type of control
you are using.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Oh, sorry -- it's a limited-to-list Combo box, populated
with various items from a named range on one of the
worksheets. Based on the value in the previous (in tab
sequence) control, OnEnter proposes the appropriate value
to be selected in ControlX, but the user can select a
different one as long as it's in the list. All that works
dandy, but if the user completely deletes the value in
ControlX and then tries to go anywhere else, he gets the
error I described.
 
Is "" one of the valid choices in the list? If not, try adding it (at the
bottom if you don't want it as a distraction).
 
Nope, no joy. Tried adding "" to the valid entries list,
and also rewrote the initial form setup so that this
control is set to null rather than "". Same error message
in both cases.
 
Gee, is replying to yourself like talking to yourself?

Just wanted to let the world know that after two weeks I still haven't figured this out. Tried various things people suggested, but still get the "Invalid Property Value" error in the scenario I originally described. Hoping somebody will have some additional ideas. Unfortunately this error seems to be coming from Windows Forms rather than Excel, and there's no error number or other clue associated with it to give me a way of researching it further.
 
Try Changing MatchRequired Property to False

I know this thread is old now but I was having the same problem. I found out that the comboBox has a property called MatchRequired and setting it to false stops the error from occuring. Hope this helps someone.

Thanks,
Chris
 
Here's what i did for my combo box.
on population assigned listindex at -1
additem("") to end of list

combobox change event
If Cmb_Details_Salesman.Value = "" Then
Cmb_Details_Salesman.MatchRequired = False
Else
Cmb_Details_Salesman.MatchRequired = True
End If
End Sub
hope this helps thank
 
Back
Top