changing value of cell by dbl click without vba?

  • Thread starter Thread starter ntl.news.com
  • Start date Start date
N

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.
 
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.
 
Did you look for code under the ThisWorkbook module as well as the worksheet
module?
 
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.

ntl.news.com said:
Yes. I even turned off macros by saying disable macro's when I open the
file.
Click to expand...
 
Back
Top