Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The below code works, but is there a better way?
The logic has to allow for 5 single premium deposits to occur on any contract anniversary. Example if the contract was issued 7/1/2008. Deposits can be made on any anniversary after 7/1/2008. Therefore 7/1/2008, 7/1/2011, 7/1/2060 are acceptable dates and 7/15/2008, 9/1/2008 , 11/16/2040 are unacceptable dates. Sub Worksheet_Change(ByVal Target As Range) Dim IMonth As Long Dim IDay As Long IMonth = Month(shtInput.Range("Issdate")) IDay = Day(shtInput.Range("issdate")) If Target.Column = 2 Then If Month(Target.Value) < IMonth Or Day(Target.Value) < IDay Then Target.Value = DateSerial(Year(Target.Value), IMonth, IDay) MsgBox ("single premium deposits are required to be on anniveries") End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code Improvements | Excel Programming | |||
Counting Consecutive Improvements | Excel Discussion (Misc queries) | |||
Performance Improvements while using RTD | Excel Programming | |||
Message Box Improvements | Excel Programming | |||
ListView to Excel Code (but needs SPEED improvements) | Excel Programming |