changing value of cell by dbl click without vba?

[ntl.news.com]

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.

 

[Don Guillett]

No can do

 

[ntl.news.com]

i've got a file here that does it, i can't see the code for it in vba, so i
turned macro's off to check if it was in vba, but it still worked.

forgive me if i am wrong, i am new to vba and excel.

 

[Dave Peterson]

Did you look for code under the ThisWorkbook module as well as the worksheet
module?

 

[ntl.news.com]

Yes. I even turned off macros by saying disable macro's when I open the
file.

 

[ntl.news.com]

Sorry guys, I am wrong you can't do it without vba, it was quite a large vba
file, the code for it was in another xla file which loads automatically with
my excel.

Yes. I even turned off macros by saying disable macro's when I open the
file.