Hello Ken, I have tried both your answers but I get:
1. Compile error: Invalid outside procedure
2. There is no change in smiley when I change the value in the target cell.
Plus.. can the target cell have a calculation in it (i.e.
=IF(B290,IF(B29=B31,"YES","NO"),"")
Thank you very much
hello everybody, I have 2 questions:
1. my worksheets contain a macro that shows, randomly, some sentences in
the status bar. I is possible to get the text to scroll allowing for
longer texts)
2. I have this sheet in which, by means of simple calculations, my
collegues and I can see if a target has been reached. I would love to be
able to see something funny happening if the target is met (like a big
smile or whatever) and also if the target is not met (an angry face).
Is it possible to do so... and if it is...how?
Thanks for all the support
--
Lisa
Save the Dogs Onlus - www.savethedogs.it