Pop Up Window when text entered into cell

Have had a look at the code, it works if i type in Yes but if i select Yes from the dropdown it doesn't work. Any ideas?

Hi,

In Excel 97, the change event is not triggered by a data validation box ...

Solution is to add a column (and if need be, hide it..) where formula is
= changedcell

HTH
Cheers
Carim

When you say enter "= ChangedCell", do you mean enter "=F5" for example? Tried that both ways and it didnt work.

If I can't get it to work then never mind, it has been a good learning experience anyway. If you have any other ideas then please let me know, if not, you help is appreciated anyway.

Thanks

Sorry ...

I mean a link to cell being changed by the validation box ...

If it does not work, you should re-enable your events ...

i.e. write a one line macro

Application.EnableEvents = True

HTH
Carim

Originally Posted by kingdt

Have had a look at the code, it works if i type in Yes but if i select Yes from the dropdown it doesn't work. Any ideas?

thats weird it works for me could be because I am using Excel2000 but I find that if I type it and then press enter to go to the next cell then I get it as well as when I select it from the list..

Hi FunkyMonk,

He is facing a known bug in Excel 97 ... which was fixed in Excel 2000

Cheers
Carim