Userform Controls (Allowing empty strings when match required = True)

[stuart010]

Hi All,

I have searched google for an effective solution to this problem, however I cannot find anything that will efficiently deal with the scenario below. Again, any help would be much appreciated.

I have a userform which has some combo box items that is populated by defined names in the workbook. The combo box items also have the match required option set to true as I want to force them to have to select a valid entry.

The user will click a command button that will take the information and perform a sub procedure clearing the comboboxes (Using the following type code Combobox1.value = "") after completion (Effectively resetting the form). The issue I have is that the user may not require to re-enter any further information and therefore terminate the form. Unfortunately I get an "invalid property value" as the control have a value that doesn't match an item on the list.

Thanks in advance.

Regards

Stuart

[JosephP]

can you post a workbook - that shouldn't happen just from what you've described there.

[stuart010]

Hi JosepthP,

Thanks, you were correct it shouldn't happen, I think my code sets focus to one of the comboboxes generating the issue above. I'll have to check through and remove it.

Thanks again.

Stuart