changing cell value by double clicking it with out vba/macros

how can i get excel to change the value of a cell from a list by double
clicking on it. e.g. cell has value "cat" then dbl clicking it changes it
to dog, then to mouse and repeats with cat again....

of course, i want to know how to do this without vba/macros.

regards.

You have a response in .excel.

"ntl.news.com" wrote:
>
> how can i get excel to change the value of a cell from a list by double
> clicking on it. e.g. cell has value "cat" then dbl clicking it changes it
> to dog, then to mouse and repeats with cat again....
>
> of course, i want to know how to do this without vba/macros.
>
> regards.

--

Dave Peterson