+ Reply to Thread
Results 1 to 5 of 5

Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

  1. #1
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

    I am experiencing an annoying little problem that I am struggling to find what is causing it. I hope someone can help me diagnose the cause as I'm not getting an error really nor does it break the code.

    I have a userform with two comboboxes (in addition to some other controls) on it that I suspect are the culprits. All these controls are locked during the userform's initialization as I don't want the user to change anything presented. Information is only available to view at this point. (the boxes have default values in them for viewing)

    With everything locked, when I click on either one of these two boxes, a box will pop up with an exclamation mark with "Invalid property value". OK closes the message, but all subsequent clicks anywhere on the userform, including the red corner X will pop up the same message. The x will close the form, but not without popping up the message one final time.

    The user has a button they can click to unlock all the fields for editing purposes. The button simply unlocks all the controls. The user having done this, and clicking on one of these two comboboxes is given the list of values to select from. There are no "Invalid property value messages." associated with this click. Everything works ok when the default value is changed.

    But if the user clicks either of those two boxes before "unlocking" them first, will result in persistent messages of Invalid property value. The userform shows it's displeasure when someone clicks on either of those two controls without first unlocking them.

    Because there is no error, I don't know where the culprit is. I've eliminated those two comboboxes and started fresh think perhaps there was some property out of whack, and recreated them with no resolve.
    There are change events associated with these two comboboxes, but I am under the impression these will not trigger unless there is a change in the existing value.
    Last edited by Jenn68; 02-13-2019 at 04:36 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

    Hello Jenn68,

    If you can post a copy of your workbook, please do. If you cannot because your data contains personal or sensitive information, please redact the information before you post. If you need to create a smaller version then be sure it mirrors your original workbook in layout and formatting. A workbook ids worth a thousand words.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

    Thank you!

    Removed

    To recreate the problem ...

    From the visible sheet, click the blue oval to launch the form.
    From the dropdown, choose an employee number
    The View / Modify employee information button will be enabled. Press it.
    Click the "Rate Code" combobox (it should be locked, you will get the arrow but no dropdown)
    Now click anywhere else on the form. You should experience the message.
    Last edited by Jenn68; 02-19-2019 at 10:04 AM.

  4. #4
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

    Has anyone tried this to see if the problem was encountered?

  5. #5
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Persistent "Invalid Property Value" Message Upon Clicking of locked Comboboxes

    Found the culprit ....

    "MatchRequired" property must be set to False, not true.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Noob, "Compile Error: Invalid Use of Property" On First line of Code (great..)
    By tvwright in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-20-2015, 05:00 PM
  2. Ribbon Problem: "Wrong Nr of Arguments or invalid property assignment"
    By CaptMac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2015, 04:17 PM
  3. [SOLVED] ComboBox - "Error: Invalid Property Used" while restricting the dropdown values
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2013, 04:26 AM
  4. Run Time Error-380 "Could not set the value property. Invalid property value"
    By Cijo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2012, 04:04 AM
  5. "Wrong number of arguments or invalid property assignment" *sigh*
    By bg_enigma1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2012, 05:54 PM
  6. Clear Form results in INCORRECT "Invalid Property" message....
    By B in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2006, 01:30 PM
  7. "Invalid property" after "Clear Form"
    By B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 12:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1