Results 1 to 3 of 3

VBA: notify when number switches from positive to negative and vice versa (Excel)

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    39

    VBA: notify when number switches from positive to negative and vice versa (Excel)

    Hello,
    I have a column in Excel with both positive and negative numbers. I would like to receive through VBA a notification on screen every time that the list of numbers switches sign. The notification is different if it goes from positive to negative than from negative to positive. It would also have to indicate at what row that change happens.
    Thank you for your help.
    Last edited by zeno1; 05-07-2012 at 05:37 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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