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.