Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two cells
Hi,
Im very new to VB and would appreciate some help. I need some code which compares two cells (AH1 & AI1) and if there is a difference then the code runs a Macro (called DisplayCalendar) Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two cells
Copy below code in Worksheet Module (Right click on Tab , Click on
"View Code" , Paste below code) Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("AH1").Value < Range("AI1").Value Then Call DisplayCalendar End If End Sub Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cells with text to cells with numeric values. | Excel Programming | |||
Comparing cells | Excel Programming | |||
comparing cells | Excel Worksheet Functions | |||
Comparing Cells | Excel Worksheet Functions | |||
Comparing Cells | Excel Worksheet Functions |