View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default 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