Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
Hello everyone,
Am having two values in A1 and B1. The cell C1 has one value. I need a msgbox to pop up if either A1 or B1 greater than C1. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
On Saturday, December 15, 2012 12:28:56 AM UTC-8, naga rajan wrote:
Hello everyone, Am having two values in A1 and B1. The cell C1 has one value. I need a msgbox to pop up if either A1 or B1 greater than C1. Please help. Hi naga rajan, Try this in the worksheet code module. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value Or Range("B1").Value Range("C1") Then MsgBox "A1 or B1 is greater than C1", vbOKOnly, "High Hopes" End If End Sub HTH Regards, Howard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
wrote:
naga rajan wrote: I need a msgbox to pop up if either A1 or B1 greater than C1. [....] Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value Or Range("B1").Value Range("C1") Then MsgBox "A1 or B1 is greater than C1", vbOKOnly, "High Hopes" End If End Sub Correction: If Range("A1") Range("C1") Or Range("B1") Range("C1") Then Also note that the Worksheet_Change event macro goes into a worksheet module, not a normal module. Right-click on the worksheet tab to open the worksheet module in the VBA window. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
On Saturday, December 15, 2012 8:15:50 AM UTC-8, joeu2004 wrote:
wrote: naga rajan wrote: I need a msgbox to pop up if either A1 or B1 greater than C1. [....] Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value Or Range("B1").Value Range("C1") Then MsgBox "A1 or B1 is greater than C1", vbOKOnly, "High Hopes" End If End Sub Correction: If Range("A1") Range("C1") Or Range("B1") Range("C1") Then Also note that the Worksheet_Change event macro goes into a worksheet module, not a normal module. Right-click on the worksheet tab to open the worksheet module in the VBA window. Whoa, good catch Joeu2004! It's not clear to me why my line produces the msgbox when both A1 & B1 are LESS than C1. And I tested my code, but missed that somehow...??? Howard |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
wrote:
If Range("A1").Value Or Range("B1").Value Range("C1") Then [....] It's not clear to me why my line produces the msgbox when both A1 & B1 are LESS than C1. Because A1 < 0 (presumably). Your if-statement reads: "if A1 is true or if B1 C1, then ....". Any non-zero value is considered "true". So "if A1 is true" is false only when A1 = 0. Since "A1 is true" is (almost) always true, the true/false value of the 2nd part (B1 C1) does not matter. "TRUE OR anything" is true. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
On Saturday, December 15, 2012 11:18:36 AM UTC-8, joeu2004 wrote:
wrote: If Range("A1").Value Or Range("B1").Value Range("C1") Then [....] It's not clear to me why my line produces the msgbox when both A1 & B1 are LESS than C1. Because A1 < 0 (presumably). Your if-statement reads: "if A1 is true or if B1 C1, then ....". Any non-zero value is considered "true". So "if A1 is true" is false only when A1 = 0. Since "A1 is true" is (almost) always true, the true/false value of the 2nd part (B1 C1) does not matter. "TRUE OR anything" is true. Thanks, good stuff to digest for lurkers like me. Howard |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX
Hello,
Thanks for the help. When I define the range to A1:A100 C1 its giving mismatch error. I want to display a msgbox when the value of A1:A100 or B1:B100 C1. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Msgbox not displaying | Excel Programming | |||
Displaying A MsgBox for X Seconds | Excel Programming | |||
MsgBox not displaying right away | Excel Programming | |||
Comparing values in two columns and displaying missing values in n | Excel Programming | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions |