Combo Box Data Validation - First Entry Blank
 

I've looked and read, but haven't found solution . . .

I'm using a combo box in a worksheet, not a user form. I've followed the
very helpful CONTEXTURES instructions, but when the combo box is selected at
double click in the cell, the combo box opens blank, and any value can be
entered without data validation error (what's typed is not in the list range
of valid values).

Validation for the cell alone works (if the combo box isn't used). The
combo box contains all the valid values and type-ahead works -- it's just
that when it opens, the blank space allows any entry and data validation
doesn't pick up on it if entered using the combo box.

Can I default to the first value (in a worksheet, not a form) and/or can I
make the free-form user entry error out? This falls under category of
"simple", "not easy" -- at least for a knuckle-draggin' non-technical
supervisor, . . . like me. Please advise.

Combo Box Data Validation - First Entry Blank
 

Hi

Right click on the combobox in design mode and select proporties. Find
"MatchRequired" and set it to True.

Regards,
Per

"questor" skrev i meddelelsen
...
I've looked and read, but haven't found solution . . .

I'm using a combo box in a worksheet, not a user form. I've followed the
very helpful CONTEXTURES instructions, but when the combo box is selected
at
double click in the cell, the combo box opens blank, and any value can be
entered without data validation error (what's typed is not in the list
range
of valid values).

Validation for the cell alone works (if the combo box isn't used). The
combo box contains all the valid values and type-ahead works -- it's just
that when it opens, the blank space allows any entry and data validation
doesn't pick up on it if entered using the combo box.

Can I default to the first value (in a worksheet, not a form) and/or can I
make the free-form user entry error out? This falls under category of
"simple", "not easy" -- at least for a knuckle-draggin' non-technical
supervisor, . . . like me. Please advise.

Combo Box Data Validation - First Entry Blank
 

I've tried that, and it still will allow any entry in that first blank line.
I've also tried deselecting the Excel validation for "Ignore Blank Cells" and
that doesn't seem to help either. Somehow, it's using the referenced
drop-down cells for the list, but not the validation / MatchRequired. Is
there another attribute I need to set? Can I force that first entry to avoid
the blank but still allow the type & autofill feature?

Thanks for the assistance.

Kind Regards,

Questor

"Per Jessen" wrote:

Hi

Right click on the combobox in design mode and select proporties. Find
"MatchRequired" and set it to True.

Regards,
Per

"questor" skrev i meddelelsen
...
I've looked and read, but haven't found solution . . .

I'm using a combo box in a worksheet, not a user form. I've followed the
very helpful CONTEXTURES instructions, but when the combo box is selected
at
double click in the cell, the combo box opens blank, and any value can be
entered without data validation error (what's typed is not in the list
range
of valid values).

Validation for the cell alone works (if the combo box isn't used). The
combo box contains all the valid values and type-ahead works -- it's just
that when it opens, the blank space allows any entry and data validation
doesn't pick up on it if entered using the combo box.

Can I default to the first value (in a worksheet, not a form) and/or can I
make the free-form user entry error out? This falls under category of
"simple", "not easy" -- at least for a knuckle-draggin' non-technical
supervisor, . . . like me. Please advise.