I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!

remove the check-mark on Error-message tab

"compu-mom" skrev:

I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!

Using Data Validation drop-down list, uncheck "Show error alert after invalid
data has been entered"


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 09:17:02 -0700, compu-mom
wrote:

I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!