+ Reply to Thread
Results 1 to 4 of 4

VB Code to detect negative value in range

  1. 04-25-2015, 11:07 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to detect negative value in range

    Hello:

    I have data in cell Range B5:AD9.

    I need VB Code to check in each cell and see if any cell has less then zero value.
    If it does then pop message saying Cell Referance : XXXX has Value

    Please refer to attached file.
    Let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  2. 04-25-2015, 11:49 PM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: VB Code to detect negative value in range

    Maybe this.....
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 04-25-2015, 11:55 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to detect negative value in range

    Hi sktneer:

    Thanks a lot, works great.
    Riz
    Reply With QuoteRegister To Reply
  4. 04-25-2015, 11:57 PM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: VB Code to detect negative value in range

    You're welcome Riz! Glad to help.
    And thanks for the feedback as well.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. code to detect cell range change
    By rachee in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2014, 06:45 PM
  2. code to detect cell range change
    By rachee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 03:10 PM
  3. VBA Code to detect Cell Changes within a Worksheet
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2011, 06:01 AM
  4. Calculating The Largest Negative Number within a Range of Positive & Negative Numbers
    By Vladmir1111 in forum Excel General
    Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  5. Detect Negative numbers
    By new@this in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2007, 05:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1