Hey,
I need to create a macro when a user enters a date in column 41, when that entered date is greater than the date in column 5 and less than the date in column 40 of the corresponding row. For example, if a user enters 3/21/09, greater than 3/10/09 located in column 5, and less than 3/30/09 located in column 40 of the same row. In turn, I'd like for this macro to show a userform when a date that meets these conditions is entered. Thanks.
Benhop
I need to create a macro when a user enters a date in column 41, when that entered date is greater than the date in column 5 and less than the date in column 40 of the corresponding row. For example, if a user enters 3/21/09, greater than 3/10/09 located in column 5, and less than 3/30/09 located in column 40 of the same row. In turn, I'd like for this macro to show a userform when a date that meets these conditions is entered. Thanks.
Benhop