Re: Happy Face Won't Work (Excel 2007)

Yes... I was modifying the code in the case structure. I was not refering to the value typed into cell H3.

I was playing around with the code. My suggestion worked when I copied the event code into a standard sub procedure and used the immediate window to test the values to get the smile to move. I noticed that negative values changed the smile, but positive numbers did not!!

PS: Please remember that I am testing in Excel 2007. I dunno if it is the same in 2003