Hi There - thanks for reading my question.

I have a data validation list and I have included a blank, however I need
people to be about to type anything they like in the blank (edit it) as well
as still be able to see the list.

Thanks again.

There's a tab on the Data|Validation dialog that lets you specify what kind of
checking you want to use.

Look at that "Error Alert" tab and you'll see the options.

Belle wrote:

Hi There - thanks for reading my question.

I have a data validation list and I have included a blank, however I need
people to be about to type anything they like in the blank (edit it) as well
as still be able to see the list.

Thanks again.

--

Dave Peterson

Ohhh - thank you Dave - one simple check box unchecked and I am away!

Thanks again

"Dave Peterson" wrote:

There's a tab on the Data|Validation dialog that lets you specify what kind of
checking you want to use.

Look at that "Error Alert" tab and you'll see the options.

Belle wrote:

Hi There - thanks for reading my question.

I have a data validation list and I have included a blank, however I need
people to be about to type anything they like in the blank (edit it) as well
as still be able to see the list.

Thanks again.

--

Dave Peterson