Creating Drop Down lists

I have created a drop down list! The problem I am having is that sometimes I
want to be able to type free form in the cell rather than using the drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam

Hi!

Disable the error alert message.

Biff

"Sam151" <[email protected]> wrote in message
news:[email protected]...
>I have created a drop down list! The problem I am having is that sometimes
>I
> want to be able to type free form in the cell rather than using the drop
> down. Can I do this? If yes, how do I do it?
>
> --
> thanks
>
> Sam

Hi Biff - thanks very much! So simple~!
--
thanks

Sam


"Biff" wrote:

> Hi!
>
> Disable the error alert message.
>
> Biff
>
> "Sam151" <[email protected]> wrote in message
> news:[email protected]...
> >I have created a drop down list! The problem I am having is that sometimes
> >I
> > want to be able to type free form in the cell rather than using the drop
> > down. Can I do this? If yes, how do I do it?
> >
> > --
> > thanks
> >
> > Sam
>
>
>

You're welcome. Thanks for the feedback!

Biff

"Sam151" <[email protected]> wrote in message
news:[email protected]...
> Hi Biff - thanks very much! So simple~!
> --
> thanks
>
> Sam
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Disable the error alert message.
>>
>> Biff
>>
>> "Sam151" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have created a drop down list! The problem I am having is that
>> >sometimes
>> >I
>> > want to be able to type free form in the cell rather than using the
>> > drop
>> > down. Can I do this? If yes, how do I do it?
>> >
>> > --
>> > thanks
>> >
>> > Sam
>>
>>
>>

Hi sam, I'm larry. Would you mind if I used your drop down code? I don't much
about writing VB but I sure like using it. Thanks, larry

"Sam151" wrote:

> I have created a drop down list! The problem I am having is that sometimes I
> want to be able to type free form in the cell rather than using the drop
> down. Can I do this? If yes, how do I do it?
>
> --
> thanks
>
> Sam