Results 1 to 6 of 6

Testing a condition and generating a message box

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2007
    Posts
    15

    Testing a condition and generating a message box

    Hello all,

    I'm trying to create a troubleshooting sheet for something that I need to do at work. Basically, I'm trying to catch a problem. I have an orderbook for a particular stock with the best bid and offers -- they are supposed to be in multiples of 100,000, however sometimes we are seeing that this is not the case. I am using the modulus operator to test any time that the values are not divisible by 100,000, so in a perfect world I am always getting a value of 0.

    Id like to create a macro that looks at my range of 10 modulus cells and tests to see if they are equal to 0. If they aren't, I'd like to pop up a message box to alert me. Also I'd like the test to run continually so I suppose it would have to be set off by a worksheet change event. I attached a very basic example sheet but need to know if what im trying to do is possible in VB.

    The modulus range I want to test is C9:D13 on sheet 2
    Attached Files Attached Files

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