Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Happy Face Won't Work (Excel 2007)

    Hi

    I can't get the happy face to work, and ideas please, the smile should change the lower the number.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    It works for me - make sure that you have enabled macros.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Hans

    Yes I have Macro's enabled.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    Works for me too, however I see there quite a few References missing, click on Tools--> References in the VBE and untick the MISSING ones if you have them too. See if it works now
    Jerry

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    Does the problem persist after quitting and restarting Excel? If you accidentally turned off event handling, the Worksheet_Change event procedure won't get called.

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Jerry

    I don't have all those missing links because I have the programmes loaded, However if i tick the VBA Project Reference I get the error attached.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Hans

    Yes the problem still occurs if close and re-open Excel

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    Try turning off all add-ins temporarily to see if the problem disappears.

    Also see Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Hans

    No luck with this, I will try your link.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  10. #10
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Hi Braddy

    its work when I try it in Excel 2003, have a look at this link
    http://support.microsoft.com/default.aspx?...kb;en-us;213835

    Not sure is there a different from 2007 versionas I am not using this version

    HTH

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  11. #11
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Francis

    It seems this just doesn't work in Excel 2007, I can get it work in Excel 2003, However it is not that important.

    Thanks to all who replied.

    Braddy
    If you are a fool at forty, you will always be a fool

  12. #12
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    With some effort, I managed to get the smile to change when I used a negative number. Try something like -0.04 or -0.004.
    Regards,
    Rudi

  13. #13
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Rudi

    Did you change the code because you can't normaly enter less than 0 or more than 100 withhout getting a warning.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  14. #14
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    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
    Regards,
    Rudi

  15. #15
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

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

    Hi Rudi

    I think it's safe to say it doesn't work in 2007 in it's origional code.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •