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.

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

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