Results 1 to 10 of 10

Message box on value

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2004
    Posts
    70

    Message box on value

    Hi all,

    I need to trigger a message box if 2 conditions are met: A1>1 and A2>1 Message "Limit Exceeded".

    On searching I've found some code but can't get it to work;

    Option Explicit

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column > 1 Then Exit Sub
    If Target.Value > Target Then MsgBox _
    "Please complete commentary section", vbCritical, "Input required"
    End Sub
    But can't get it to work. What is the "Target.Column" Refering to please ?
    Last edited by OptionTrader; 11-29-2009 at 12:45 PM.

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