+ Reply to Thread
Results 1 to 3 of 3

bassfisher

  1. #1
    Registered User
    Join Date
    09-27-2005
    Posts
    5

    bassfisher

    hello,
    i am a newbie when it comes to to programing. i am attempting to have a macro run when the value of a cell is changed. i have a macro that does what i want it to, diplays an erro message and plays a sound, but just cannot seem to make it work based on the cell value. any help would be greatly appreciated! thanks in advance

    bassfisher

  2. #2
    Tom Ogilvy
    Guest

    Re: bassfisher

    One thing you haven't said is what causes the value of the cell to change.

    In any event, you could use the calculate event and use a static variable to
    store the last value of the cell

    See Chip Pearson's page on events
    http://www.cpearson.com/excel/events.htm

    --
    Regards,
    Tom Ogilvy


    "bassfisher" <bassfisher.1w0qqd_1127826341.3884@excelforum-nospam.com> wrote
    in message news:bassfisher.1w0qqd_1127826341.3884@excelforum-nospam.com...
    >
    > hello,
    > i am a newbie when it comes to to programing. i am attempting to have
    > a macro run when the value of a cell is changed. i have a macro that
    > does what i want it to, diplays an erro message and plays a sound, but
    > just cannot seem to make it work based on the cell value. any help
    > would be greatly appreciated! thanks in advance
    >
    > bassfisher
    >
    >
    > --
    > bassfisher
    > ------------------------------------------------------------------------
    > bassfisher's Profile:

    http://www.excelforum.com/member.php...o&userid=27585
    > View this thread: http://www.excelforum.com/showthread...hreadid=471080
    >




  3. #3
    Registered User
    Join Date
    09-27-2005
    Posts
    5
    hello tom,

    the result is achieved after a few "IF" formulas and a "SUM" formula, if the value of "FE11" changes from "0" to "1", i would like it to play a warning sound and display a warning message on the screen alerting the user of a conflict. as i said, i am new to this and not as experienced in programming but am trying to learn !

    thanx for your help so far

    bassfisher

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1