Validation List (Ver 97, WIN 98)

Topic

New Reply

I am using data validation with the list option for several cells in a data user form. I have a user form where I would like to have the drop down list to choose from but permit the user to override the formula by entering an item that is not on the list. Instead of data validation, I’m really using the drop down list to speed up data entry and don’t wish to capture every situation with the validation drop down list (i.e., list would be come too long and cumbersome). Is there anyway to create a drop down box the user can select from to fill the cell and also permit the user to type in an answer if the item is not on the list without getting an error message that occurs when “pure” data validation is used? Is this something that can only be accomplished through VBA? THANKS.

Reply | Quote

Replies

You can use a combo box (from CONTROL TOOLBOX) with the fill range linked to a range of values.
The combobox allows (if the MatchRequired property is false) a new value to be entered.

The combo box would link to the cell you want to add the item to.

No VB is required. Though you need to add a separate comboboxes for each the “several” cells.
Steve

Reply | Quote

I was able to do what I think you’re asking by using data validation.

I created a list of possible values for the cell, and set up data validation for another cell. I unchecked the “Show error alert…” box from the Error Alert tab, and likewise unchecked “Show input message…” from the Input Message tab. From there, I just did the normal data validation stuff: Allowed a list, set the source, checked the appropriate check boxes.

If I decide not to use the list, I’ll just type my own entry in the cell – ignoring the list completely.

Does the attached illustrate well enough, or did I completely miss the question?

Reply | Quote

Perfect….Many, many thanks!

Reply | Quote