+ Reply to Thread
Results 1 to 4 of 4

VBA to have msg box appear if range >x

  1. 04-03-2013, 09:25 PM #1
    maximus0120 is offline
    Registered User
    Join Date
    07-20-2012
    Location
    New York
    MS-Off Ver
    excel 2010
    Posts
    16

    VBA to have msg box appear if range >x

    Hi guys, Im looking to have a code that will display a message box when any cell in a range of cells, is greater than another cell i select. For example, if any cell in s2:s730 is greater than cell v2.
    Reply With QuoteRegister To Reply
  2. 04-03-2013, 09:39 PM #2
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: VBA to have msg box appear if range >x

    This should do it:
    Please Login or Register  to view this content.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---
    Reply With QuoteRegister To Reply
  3. 04-03-2013, 10:24 PM #3
    maximus0120 is offline
    Registered User
    Join Date
    07-20-2012
    Location
    New York
    MS-Off Ver
    excel 2010
    Posts
    16

    Re: VBA to have msg box appear if range >x

    Thanks alot, it worked great
    Reply With QuoteRegister To Reply
  4. 04-03-2013, 11:03 PM #4
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: VBA to have msg box appear if range >x

    No problem maximus
    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)

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